You can use one of the following to know the structure of a table
Generate SQL Script option from Enterprise Manager/Management Studio select * from information_schema.columns where table_name='table_name' EXEC sp_help 'table_name' EXEC sp_columns 'table_name' In Query Analyser type the name of the table, highlight it and press Alt+F1
Tags: t-sql, sql_server, table_structure,