Find a Column by Name in User Tables


/ Published in: SQL
Save to your folder(s)

Perform a search of all user tables in the current database to locate a column defined in a user table that matches a certain name. The first query looks for an exact column name and the second one returns all column names which match a keyword (using the LIKE operator).

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.