MsSql: Select table column names
By kenglish
Sometimes I need to match table column names in Microsoft SQL Server. This seems to be the best way to do it:
SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%COST%'
August 18th, 2009
This author published 69 posts in this site.Share
