Using the table tablename, write the query as follows -
Select * from information_schema.columns where table_name = tablename
How to find out column names and their datatypes in a given table using a query in SQL Server?
Posted by
Rajesh Rolen
at
Friday, October 23, 2009
Labels: SQL , SQL Interview Questions , sqlserver
0 comments:
Post a Comment