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: 5436
Answer:

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


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response