Friday, October 23, 2009

How to find out column names and their datatypes in a given table using a query in SQL Server?

Using the table tablename, write the query as follows -
Select * from information_schema.columns where table_name = tablename

Share This!

No comments:

Powered By Blogger · Designed By Seo Blogger Templates