Different ways to know 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