Answers for "sql how to search all tables for a value"

SQL
0

sql search all tables for attributes

SELECT
  sys.columns.name AS ColumnName,
  tables.name AS TableName
FROM
  sys.columns
JOIN sys.tables ON
  sys.columns.object_id = tables.object_id
WHERE
  sys.columns.name = 'ColumnName'
Posted by: Guest on September-20-2021

Code answers related to "sql how to search all tables for a value"

Code answers related to "SQL"

Browse Popular Code Answers by Language