Code Snippet posted by:
Self-Innovator | Posted on: 10/15/2012 | Category:
SQL Server Codes | Views: 323 | Status:
[Member] |
Points: 40
|
Alert Moderator
Hi,
The below code is to find out the specific records consumed by list of tables in a Database sql Server 2008.
Ex:- Search for string 'INDIA'
SELECT Tbl.NAME AS TABLE_NAME,SCHEMA_NAME(SCHEMA_ID) AS SCHEMA_NAME,Cln.NAME AS COLUMN_NAME FROM SYS.tables AS Tbl
INNER JOIN
SYS.columns as Cln ON Tbl.object_id=Cln.object_id WHERE Cln.name LIKE 'INDIA%'
Join Hands Change lives
Thanks & Regards
Straight Edge Society