Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the function for the data types?
Message
From
11/09/2006 15:07:15
Keith Payne
Technical Marketing Solutions
Florida, United States
 
 
To
11/09/2006 14:03:47
Marc Levesque
La Prairie, Quebec, Canada
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: What is the function for the data types?
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01152821
Message ID:
01152848
Views:
22
>I know I can use syscolumns table, but is exist a function to use in a select from ?

For user-defined types: SELECT * FROM dbo.INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS

For built-in types you have to hard code the names.
Previous
Reply
Map
View

Click here to load this message in the networking platform