How to Retrieve Column Names of a Table in SQL Server 2012?

3

Reply

How to Retrieve Column Names of a Table in SQL Server 2012?

Deepak Kamboj

12y

2.2k

0

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.yourTableName')

12y

Ravikumar G

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME like 'YourTableName'

12y

ujjal naskar

exec sp_columns TableName

12y