/SQL/Sql server search column name in all tables

Sql server search column name in all tables

SELECT      COLUMN_NAME AS 'ColumnName'
            ,TABLE_NAME AS  'TableName'
FROM        INFORMATION_SCHEMA.COLUMNS
WHERE       COLUMN_NAME LIKE '%MyName%'
ORDER BY    TableName
            ,ColumnName;

Source: stackoverflow.com

Get all tables with column name 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;

Source: stackoverflow.com

Search for column name in sql db when i don't know which table it is in

Select * from  INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME LIKE '%MyName%'

Source: stackoverflow.com

Similar codes

0 vote247 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
28 votes218 views4 answers
Mysql delete database
SQL
0 vote186 views1 answer
Check if has alpha characters sql
SQL
1 vote235 views1 answer
How to between in sql
SQL
0 vote250 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
14 votes246 views4 answers
Online sql compiler
SQL
-1 vote239 views2 answers
First letter capital in mysql query
SQL
7 votes259 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote250 views1 answer
Sql decimal to 2 places
SQL
0 vote218 views1 answer
Sort by last two number sql
SQL