HI all,

Well the point of discussion is to have a script by which i can get all the column name and table name in a db where the data length is 9 digit and the datatype should be varchar,int.AS because we have a ID column with datatype as varchar & Int in different table.

So as this is a rarer request in any IT forum IT will be a nice one for all to learn it from the giants how it is done.

So kindly help me out for which i will be very thankful to u all.