Dot Net Point
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment