/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

1 vote123 views2 answers
Select only columns that are not empty oracle sql
SQL
3 votes130 views1 answer
Apex set debug level
SQL
0 vote172 views4 answers
Stored procedure sql
SQL
0 vote103 views1 answer
Sort by last two number sql
SQL
0 vote103 views1 answer
Delete a record from a table sqlite3
SQL
0 vote120 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote108 views1 answer
SQL check if record exist
SQL
0 vote111 views2 answers
Greater than sql server
SQL
0 vote121 views1 answer
Hashpass
SQL
15 votes111 views5 answers
Show tables in oracle
SQL