Adding a new column to a MS SQL Table safely

April 8th, 2008 admin Posted in sql |

How could we check if a column exists and add it to a table if it doesn't? Very easily!

 
IF NOT EXISTS
	(SELECT * FROM syscolumns
	WHERE id = OBJECT_ID(N'[MyTable]') AND name = 'MyColumn')
             ALTER TABLE dbo.MyTable ADD MyColumn INT

Enjoy!

9 Responses to “Adding a new column to a MS SQL Table safely”

  1. Jon Says:
    April 9th, 2008 at 7:45 pm

    Nice little tip.

  2. JACK Says:
    July 6th, 2010 at 7:05 pm

    < blockquote >< a href=”http://pillspot.org/”>Pillspot.org. Canadian Health&Care.Best quality drugs.Special Internet Prices.No prescription online pharmacy. High quality pills. Buy drugs online< /a >…

    Buy:Levitra.Tramadol.Viagra Professional.Cialis.VPXL.Cialis Super Active+.Cialis Soft Tabs.Viagra Super Active+.Maxaman.Viagra Super Force.Viagra.Viagra Soft Tabs.Cialis Professional.Soma.Super Active ED Pack.Zithromax.Propecia….

  3. TIMOTHY Says:
    July 15th, 2010 at 9:26 pm

    < blockquote >< a href=”http://pillspot.org/”>Pillspot.org. Canadian Health&Care.Best quality drugs.Special Internet Prices.No prescription online pharmacy. Low price pills. Buy pills online< /a >…

    Buy:Prevacid.Synthroid.Human Growth Hormone.Zovirax.Accutane.Actos.Prednisolone.Nexium.Lumigan.Petcam (Metacam) Oral Suspension.Retin-A.Valtrex.Mega Hoodia.100% Pure Okinawan Coral Calcium.Zyban.Arimidex….

  4. 7 Says:
    August 29th, 2010 at 7:42 am

    7 http://AWESOMEBABYCLOTHES.INFO/tag/P 7 : P…

    P…

  5. MX Says:
    August 29th, 2010 at 10:02 am

    00a amp power/ http://ACEHARDWAREE.INFO/tag/QSC MX 10 : 00a amp power/…

    QSC…

  6. leviton Says:
    August 29th, 2010 at 10:37 am

    leviton http://wlevitoncy6k.02JEEPPARTS.US/tag/lutron+leviton+GFCI/ : lutron…

    lutron…

  7. slingbox Says:
    August 29th, 2010 at 9:22 pm

    Download http://zbest76aco0.02JEEPPARTS.US/tag/Download+software+slingbox/ : Download…

    Download…

  8. MA Says:
    August 29th, 2010 at 10:03 pm

    Chambers http://nbath8tfqdgl.bestpartsstore.info/tag/Herb+Chambers+Auto+MA/ : Auto…

    Chambers…

  9. ada Says:
    August 30th, 2010 at 3:18 am

    ada http://aadapor.AUTOSECTIONS.INFO/tag/Automatic+Operators+ada+Compliant/ : Compliant…

    ada…

Leave a Reply

You must be logged in to post a comment.