Home » Questions » Computers [ Ask a new question ]

SQL query for a database scheme

SQL query for a database scheme

In SQL Server how do you query a database to bring back all the tables that have a field of a specific name?

Asked by: Guest | Views: 223
Total answers/comments: 3
Guest [Entry]

"The following query will bring back a unique list of tables where Column_Name is equal to the column you are looking for:

SELECT Table_Name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE Column_Name = 'Desired_Column_Name'
GROUP BY Table_Name"
Guest [Entry]

"SELECT Table_Name
FROM Information_Schema.Columns
WHERE Column_Name = 'YourFieldName'"
Guest [Entry]

"I'm old-school:

SELECT DISTINCT object_name(id)
FROM syscolumns
WHERE name = 'FIELDNAME'"