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%’