Different ways to know structure of a table
You can use one of the following to know the structure of a table
1 Generate SQL Script option from Enterprise Manager/Management Studio
2 select * from information_schema.columns where table_name='table_name'
3 EXEC sp_help 'table_name'
4 EXEC sp_columns 'table_name'
5 In Query Analyser type the name of the table, highlight it and press Alt+F1