Select columns for a table in SQL Server

To select the columns in a specified table in SQL Server, use this code:

SELECT c.name FROM sys.columns c, sys.tables t WHERE t.name = 'table_name' AND c.object_id = t.object_id

Technical Consultant