mmadrigal
mmadrigal

Reputation: 95

How to select valid SQL Server datatypes?

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:

enter image description here

Img Link: http://puu.sh/m4VpV/65bcb8dca6.png

Thanks for your help.

Upvotes: 0

Views: 88

Answers (1)

Pரதீப்
Pரதீப்

Reputation: 93754

Use SYS.TYPES system view

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

Upvotes: 4

Related Questions