DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets Manager

Snippets has posted 5883 posts at DZone. View Full User Profile

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

10.17.2007

| 134557 views |

        // Check to see if column exists and then create if not

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

Tags: