Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

SQL -> Check Column Exists In Table, If Not, Add

DZone's Guide to

SQL -> Check Column Exists In Table, If Not, Add

· Database Zone ·
Free Resource

Read the 2019 State of Database DevOps Report for the very latest insights


IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ‘TEST’ AND COLUMN_NAME = ‘TEST_DATE’)
BEGIN
   ALTER TABLE TEST ADD TEST_DATE DATETIME
END


Read the 2019 State of Database DevOps Report for latest insights into DevOps adoption among SQL Server professionals, and the benefits and challenges of including the database in DevOps initiatives

Topics:
database ,sql

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}