OK we are now 20 posts into your request and the details of what you want is still changing with each post. We can't see over your shoulder, we are not familiar with your system or what you want to retrieve out of it. There have been a number of people trying to help. You have to help us help you. Give us a detailed explanation of what you want.
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 .
What does that mean? Do you want only varchar fields that a numeric value that has a length of 9? Does it count as a match if the column has other data?
Taking the first script posted you could change the where clause find what you are looking for.
pure pseudocode but...
where datalength(column) = 9 and isnumeric(coliumn) = 1
If you explain clearly (yes we know it is clear to you) in a way that somebody else can understand it, we will be happy to help you.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/