Search column names for SQL Keyword being used

[ter79]

Does anyone know how I can search the column names of all the tables in a database and see if any of the column names are using SQL Keywords.

I want get a list of the table and column so I can go to that table to rename the column.

Example:

A table name Test has a column named "Name", I want to get the table name and column name

However, if the same table has a column name of "EmployeeName", I don't want to list that column since the column name is not an exact match to a SQL Keyword

Hopefully that made sense.

Thanks in advance

 

[SQLDenis]

example

select table_name,column_name,* from information_schema.columns
where column_name ='name'

put all the keywords in a table and do a join

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/