Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieve Default Value
Message
From
18/10/2001 09:51:24
 
 
To
17/10/2001 22:09:36
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00570020
Message ID:
00570216
Views:
20
>>Does anybody know how can I retrieve a "default" value from a field using t-sql?
>Sorry I forgot the word "default"
>>Thanks in advance.

Check information_schema.columns:
Select column_name, column_default 
  From information_schema.columns 
  Where table_name="mytable"
You can find about other column settings if you select * instead. HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform