sql server - finding sql reserved words used as column names -

i'm getting started (transititioning to) sql server, unfortunately company has developers have been doing table scripting, etc. on cursory glance found several tables have column names sql reserved words. in db2 ibm i, query system catalogs reserved words & wondering if has script(or stored procedure) sql server (currently on version 2012) goal clean , have tables rebuilt proper column names , script orders of magnitude faster looking @ each table's column listing.

stripped , modified validation routine

for sql server's reserved words

declare @reserved table (word varchar(100)) insert @reserved values ('add'),('all'),('alter'),('and'),('any'),('as'),('asc'),('authorization'),('backup'),('begin'),('between'),('break'),('browse'),('bulk'),('by'), ('cascade'),('case'),('check'),('checkpoint'),('close'),('clustered'),('coalesce'),('collate'),('column'),('commit'),('compute'),('constraint'), ('contains'),('containstable'),('continue'),('convert'),('create'),('cross'),('current'),('current_date'),('current_time'),('current_timestamp'), ('current_user'),('cursor'),('database'),('dbcc'),('deallocate'),('declare'),('default'),('delete'),('deny'),('desc'),('disk'),('distinct'), ('distributed'),('double'),('drop'),('dump'),('else'),('end'),('errlvl'),('escape'),('except'),('exec'),('execute'),('exists'),('exit'),('external'), ('fetch'),('file'),('fillfactor'),('for'),('foreign'),('freetext'),('freetexttable'),('from'),('full'),('function'),('goto'),('grant'),('group'), ('having'),('holdlock'),('identity'),('identity_insert'),('identitycol'),('if'),('in'),('index'),('inner'),('insert'),('intersect'),('into'),('is'), ('join'),('key'),('kill'),('left'),('like'),('lineno'),('load'),('merge'),('national'),('nocheck'),('nonclustered'),('not'),('null'),('nullif'), ('of'),('off'),('offsets'),('on'),('open'),('opendatasource'),('openquery'),('openrowset'),('openxml'),('option'),('or'),('order'),('outer'),('over'), ('percent'),('pivot'),('plan'),('precision'),('primary'),('print'),('proc'),('procedure'),('public'),('raiserror'),('read'),('readtext'),('reconfigure'), ('references'),('replication'),('restore'),('restrict'),('return'),('revert'),('revoke'),('right'),('rollback'),('rowcount'),('rowguidcol'),('rule'), ('save'),('schema'),('securityaudit'),('select'),('semantickeyphrasetable'),('semanticsimilaritydetailstable'),('semanticsimilaritytable'),('session_user'), ('set'),('setuser'),('shutdown'),('some'),('statistics'),('system_user'),('table'),('tablesample'),('textsize'),('then'),('to'),('top'),('tran'),('transaction'), ('trigger'),('truncate'),('try_convert'),('tsequal'),('union'),('unique'),('unpivot'),('update'),('updatetext'),('use'),('user'),('values'),('varying'), ('view'),('waitfor'),('when'),('where'),('while'),('with'),('within group'),('writetext')  select a.*    information_schema.columns   join  @reserved     on  column_name = word