SELECT COLUMN_NAME AS 'ColumnName'
,TABLE_NAME AS 'TableName'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%MyName%'
ORDER BY TableName,ColumnName;
Refer: http://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name
Refer: http://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name
This comment has been removed by the author.
ReplyDeleteAt Indian Cyber Army, applicants wishing to build up profession in Ethical hacking and Cyber security will motivate opportunity to take in the abilities for Describe Footprinting, Scanning, and Enumeration, Hacking Web servers and Web applications, DoS, SQL infusion, Buffer flood assaults, Cryptography, Wireless hacking, Linux Hacking, Countermeasures, Ethical hacking training on continuous tasks alongside moral hacking arrangement preparing.
ReplyDelete