Tuesday, 31 January 2017

Is it possible that I can query for names of all tables which contain column with name

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 

3 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. At 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

Tweets by @sriramperumalla