Microsoft SQL — TSQL — How To Check If Field Exists In a Database

Microsoft SQL — TSQL — How To Check If Field Exists In a Database

Sometimes you may need to verify if a field (Column) name exists in a table.

Using the query below you may find out if it exists:

IF EXISTS(

SELECT

*

FROM

INFORMATION_SCHEMA.COLUMNS

WHERE

COLUMN_NAME like ‘%Column%’

)

SELECT ‘found’ AS search_result ELSE SELECT ‘not found’ AS search_result;

SELECT

TABLE_NAME,

COLUMN_NAME

FROM

INFORMATION_SCHEMA.COLUMNS

where COLUMN_NAME like ‘%Column%’

Reference: https://chartio.com/learn/databases/using-information-schema-views-to-check-to-see-if-table-exists-in-sql-server/