Steve Jones - SSC Editor (1/9/2012)
Ivan Mohapatra (1/9/2012)
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 digitdata length or data type? -Data length
and the datatype should be varchar,int.AS because we have a ID column with datatype as varchar & Int in different table.
The sentence (or fragment) above doesn't make any sense. What is "varchar,int.as"? Yo need to slow down and write a description that makes sense.
Below is a Example what i mean to say and my kind request kindly read my request seriously and understand it before u all reply.
Well there are 60 table in 1 Db there is a ID column in where there are 9 digit data.like 999999999,888888888
well in this 60 table there is around 20 column where 9 digit data.like 999999999,888888888 exits AND when i found there is two kind of datatype is been used 1 is varchar and another is INT for this ID column in different tables. i mean in one table the datatype for ID column is varchar and in another table ID column is INT.
So What i want is a script by which i can get all the table name and column name in this DB
where len of Data is 9 digit data.like 999999999,888888888 .