Stone Coast Web Design's Weblog

SELECT    
ORDINAL_POSITION  ,
COLUMN_NAME  ,
DATA_TYPE  ,
CHARACTER_MAXIMUM_LENGTH  ,
IS_NULLABLE  ,
COLUMN_DEFAULT
FROM     INFORMATION_SCHEMA.COLUMNS 
WHERE     TABLE_NAME = 'MyAwesomeTable' 
ORDER BY   ORDINAL_POSITION ASC; 

Another method is

sp_help 'tablename'