Never been to TextSnippets 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'.


    SELECT * FROM [information_schema].[columns]
    WHERE    table_name   = 'Customer'
    AND      table_schema = 'dbo'
    AND      column_name  = 'FavoriteColorId'
    ALTER TABLE [dbo].[Customer]
    ADD FavoriteColorId int

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