Friday, 14 November 2014

Get all column of a table

Get all column of a table 

SELECT *FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Customers'
go

sp_Help 'Customers'
go

SELECT *FROM sys.all_columns where object_id=OBJECT_ID('Customers')

No comments:

Post a Comment