DOT NET ACADEMY
Dot Net Interview Questions and Tutorials By Dr. Rajesh Rolen
Home
ASP.NET Interview Questions
+
C#.NET and VB.NET Interview Questions
OOPs Interview Questions
+
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:
Post a Comment
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment