Table Info

[Phylum]

IS there a command or object that I can use that will tell me the current schema of a table in an SQL database? All I want returned is the column names, data types, primary key info, index info, etc.

 

[PlausiblyDamp]

Have a look under help for INFORMATION_SCHEMA, you should be able to get what you want from there on a SQL7 / SQL 2000 server.