Jag har löst det så här när jag behövde göra en förändring av databasen under drift:
Kod:
data.CommandText = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[tblTradeShows]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[tblTradeShows]([id] [int] IDENTITY(1,1) NOT NULL,[name] [nvarchar](50) NULL,[description] [nvarchar](1000) NULL,[startdate] [smalldatetime] NULL,[enddate] [smalldatetime] NULL,[url] [nvarchar](200) NULL,[representative] [nvarchar](500) NULL,[city] [nvarchar](50) NULL,[stand] [nvarchar](10) NULL,[products] [nvarchar](500) NULL) ON [PRIMARY] END";
data.ExecuteNonQuery();