Never been to CodeSnippets 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 (or not, you can keep them private!)

Scripting schema updates in MSSQL #1 (See related posts)

This SQL statement will alter a table only if a column in the table to be altered does NOT contain a column named 'FavoriteColorId'.

From: http://haacked.com/

IF NOT EXISTS
(
    SELECT * FROM [information_schema].[columns]
    WHERE    table_name   = 'Customer'
    AND      table_schema = 'dbo'
    AND      column_name  = 'FavoriteColorId'
)
BEGIN
    ALTER TABLE [dbo].[Customer]
    ADD FavoriteColorId int
to sql tsql database mssql schema update tables microsoft columns query scripting information_schema alter altering by chrelad on Wed Aug 08 19:42:30 +0000 2007

Comments on this post

chrelad posts on Aug 08, 2007 at 19:46
If anyone knows how to retrieve a column description from a MSSQL database, please post... It would be extremely helpful.

Thanks in advance!

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


Related Posts