Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesi'd like to grab all the defaults from a specific table but have no idea how to do it! i've been using sp_columns but its bringing back way to much info for me what i'd like is to bring back the column name and its corresponding default...can this be done? any help in the right direction would be much appreciated, cheers!
Post Follow-up to this messageUse something like this: SELECT COLUMN_NAME, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='YourTabl e' Razvan
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread