/SQL/Sql select column name like from multiple tables

Sql select column name like from multiple tables

USE AdventureWorks 
GO 
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%EmployeeID%'
ORDER BY schema_name, table_name;

Source: dba.stackexchange.com

Similar codes

0 vote301 views1 answer
Top 3 salary in sql
SQL
1 vote301 views1 answer
Oracle compile schema
SQL
0 vote319 views2 answers
Mysql dump database tables only
SQL
4 votes284 views3 answers
Oracle sql first day of quarter
SQL
0 vote238 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote271 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
5 votes299 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote278 views1 answer
Mysql use password error
SQL
6 votes326 views2 answers
Oracle trigger
SQL
9 votes287 views5 answers
Sql limit
SQL