Find Column Name in Database July 26, 2012 Get link Facebook X Pinterest Email Other Apps SELECT t.name AS table_name,SCHEMA_NAME(schema_id) AS schema_name,c.name AS column_nameFROM sys.tables AS tINNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_IDWHERE c.name LIKE 'Date%'ORDER BY schema_name, table_name Comments
Comments
Post a Comment