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

Slow SQL Server? These SentryOne resources share tips and tricks for not only troubleshooting SQL Server performance issues, but also preventing them before they hit your production environment.


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


Database monitoring tools letting you down? See how SentryOne empowers Enterprises to go faster.

Topics:
database ,sql

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}