sql server join sys.columns to sys.tables | SQL Server Search by Column Name in a Database | DBA THINGS

sql server join sys.columns to sys.tables | SQL Server Search by Column Name in a Database

0

Sachin Diwakar

Sharing creates magic!!

Facebook Twitter LinkedIn 

SQL Server Search by Column Name in a Database

SELECT sys.columns.name AS ColumnName, sys.tables.name AS TableName FROM sys.columns JOIN sys.tables ON sys.columns.object_id ...

%d bloggers like this: