SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
--WHERE TABLE_NAME = <tablename>
add where condition if you want only details of particular table
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/