Phylum Posted August 20, 2003 Posted August 20, 2003 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. Quote
Administrators PlausiblyDamp Posted August 21, 2003 Administrators Posted August 21, 2003 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. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.