Friday, September 11, 2009

Query to get the all field names of a table - sql

select A.name from sys.columns A join sys.tables B on A.object_id=b.object_id and B.name='tablename'

No comments: