Never been to DZone Snippets before?

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

SQL -> Check Column exists in table, if not, add (See related posts)

// 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
to sql table select column exists by dubby on Wed Oct 17 04:58:41 -0400 2007

You need to create an account or log in to post comments to this site.


Click here to browse all 4834 code snippets

Related Posts