Structure of the table

Structure of the table :

Select * from information_schema.columns where Table_name = 'table_name'

Through SP

exec sp_columns table_name

exec sp_help table_name