/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 vote108 views1 answer
Key validation sql
SQL
0 vote120 views1 answer
Load data infile mariadb slow
SQL
36 votes119 views3 answers
Add column in mysq
SQL
0 vote110 views1 answer
Get the First and Last Word from a String or Sentence
SQL
5 votes102 views2 answers
Mysql where in array
SQL
0 vote112 views1 answer
Unique index in mysql
SQL
0 vote102 views1 answer
Postgres declare variable
SQL
1 vote118 views1 answer
UseSqlServer no definition
SQL
0 vote119 views1 answer
Space not removing from column in sql
SQL
1 vote119 views1 answer
Sql group by sum with condition
SQL