Searches for column names inside a database of a SQL tables

PHOTO EMBED

Fri Apr 01 2022 23:48:45 GMT+0000 (UTC)

Saved by @windowninja #sql

SELECT Table_Name, 
    Column_Name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'EDM-PRD'
   AND COLUMN_NAME LIKE '%cost%';
content_copyCOPY

https://solutioncenter.apexsql.com/how-to-search-for-column-names-in-sql-server/