/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 vote182 views1 answer
Doesn't have default value mysql
SQL
13 votes245 views3 answers
Mysqldump structure only
SQL
0 vote199 views1 answer
Sql delete dastabase
SQL
1 vote188 views1 answer
List all triggers in SQL Server
SQL
4 votes207 views2 answers
Delete all table oracle
SQL
0 vote205 views1 answer
How convert into in in sql query
SQL
0 vote177 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote178 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
1 vote190 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
-1 vote199 views1 answer
Concat two columns in sql server
SQL