Answers for "sql query select column from table where column name"

find table from column name in sql

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%MyName%'
ORDER BY    TableName
            ,ColumnName;

Posted by: Guest on July-20-2020

Code answers related to "sql query select column from table where column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query select column from table where column name"

Code answers related to "sql query select column from table where column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql query select column from table where column name"

Code answers related to "sql query select column from table where column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us