How to select valid SQL Server datatypes?

Question

I'm looking for a way to select every valid SQL Server datatypes to load a combobox with that values, but I don't know where I can select it values.

An example for what I want to do is this:

Thanks for your help.

You can look at the sys.types view. But be warned it will return ALL the datatypes including those that are deprecated (ie. text) and others that really shouldn't be used (timestamp, sql_variant). There is no automatic way to create nvarchar(32) and nvarchar(max). — Sean Lange
– Sean Lange, Commented Dec 22, 2015 at 17:22

Pரதீப் · Accepted Answer · 2015-12-22 17:21:30Z

4

Use SYS.TYPES system view

select name 
from sys.types
where is_user_defined = 0 -- SQL Server system data type.

answered Dec 22, 2015 at 17:21

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you so much, that was what I wanted. :)