Skip to content

Instantly share code, notes, and snippets.

@mikaelweave

mikaelweave/add_column_if_not_exist.sql

Created July 15, 2015 22:29
Show Gist options
  • Save mikaelweave/e5d32e8668c729ac2ab5 to your computer and use it in GitHub Desktop.
Save mikaelweave/e5d32e8668c729ac2ab5 to your computer and use it in GitHub Desktop.
Download ZIP
Add column if it doesn't already exist
Raw
add_column_if_not_exist.sql
IF EXISTS (
SELECT *
FROM sys.columns
WHERE object_id = OBJECT_ID(N'[dbo].[Person]')
AND name = 'ColumnName'
)
ALTER TABLE dbo.Person
ADD ColumnName VARCHAR(64)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment