/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

-3 votes134 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote142 views1 answer
Declare or use variable in snowflake
SQL
15 votes156 views3 answers
Create table with primary key auto increment in sql
SQL
5 votes131 views1 answer
Postgresql functions
SQL
10 votes134 views5 answers
Create table mysql query
SQL
-1 vote139 views1 answer
Can pandas fetch data from sql
SQL
0 vote133 views1 answer
Sql server get date of previous sunday
SQL
0 vote157 views1 answer
Calculer pourcentage mysql
SQL
16 votes137 views6 answers
Mysql find and replace
SQL
4 votes117 views1 answer
Sql list users and roles
SQL