Snippets has posted 5883 posts at DZone. View Full User Profile
// 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â€™)
ALTER TABLE TEST ADD TEST_DATE DATETIME
DZone's 170th Refcard is an essential reference to Camel, an open-source, lightweight, integration library. This Refcard is authored by...