/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 vote198 views1 answer
Mysql command line ubuntu
SQL
6 votes186 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote158 views1 answer
Sqlalchemy existing database
SQL
5 votes190 views1 answer
Alter table add comment oracle
SQL
8 votes195 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote203 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote202 views1 answer
Write a query to create an empty table from an existing table?
SQL
14 votes192 views3 answers
Sql trim from string
SQL
2 votes215 views2 answers
Spring where to put the data sql
SQL
0 vote195 views1 answer
Joins vs includes
SQL