Query To Get The Column Name,DataType, And Length of columns in a Tables?

Posted by Lakhangarg on 9/20/2009 | Category: Sql Server Interview questions | Views: 7030

Answer:

select column_name, data_type, character_maximum_length from information_schema.columns
where table_name ={Table Name}

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Query to Select n Rendom Records From a Table in t ...

Next > : How we can Get List of Triggers?

More Interview Questions by Lakhangarg

Latest Interview Questions