Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get default values
Message
From
18/10/2001 10:35:58
 
 
To
18/10/2001 09:53:25
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00358965
Message ID:
00570247
Views:
20
>I know it's old but I see you didn't get a response. See if this works for you:
>
Select column_name, column_default
>  From information_schema.columns
>  Where table_name="mytable"
>I found this through a message reference by Sergey :) HTH

Yes, a year and a half is old! :)

I finally did find the solution, but thanks anyway! Funny thing is that haven't had an occasion to use that solution since! :)
Sylvain Demers
Previous
Reply
Map
View

Click here to load this message in the networking platform