SQL Server table structure
Hi,
i want to know is there any command other than SP_help or SP_columns to see the STRUCTURE of TABLE.
Software/Hardware used:
sql server
Software/Hardware used:
sql server
ASKED:
June 11, 2010 4:05 AM
UPDATED:
June 16, 2010 12:25 AM
Answer Wiki:
Yes.
If you are using SQL 2000 or older then query the INFORMATION_SCHEMA.tables and INFORMATION_SCHEMA.columns system views.
If you are using SQL 2005 or newer then query the sys.tables and sys.columns catalog views.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
