数据库的操作，判断是否存在

判断表是否存在，判断表里的列是否存在

Go
If exists( SELECT table_name  FROM information_schema.TABLES WHERE table_name ='Configuration')
Begin
 If (not exists(select [Key] from [Configuration] where [Key]='SyncJobIntervalInSeconds'))
	Begin
		INSERT INTO [dbo].[Configuration]([Key],[Value],[Description],[Category]) VALUES('SyncJobIntervalInSeconds','30','','Sync Service');
	End
End

判断表和触发器是否存在

If exists( SELECT table_name  FROM information_schema.TABLES WHERE table_name ='SyncJob') and not exists(select name from sysobjects where name='SyncJob_update' and type='tr') 
BEGIN
   exec ('CREATE TRIGGER SyncJob_update ON SyncJob AFTER INSERT,UPDATE AS BEGIN update SyncJob set ModifiedBy = SUSER_SNAME(), ModifiedDate= GetDate() END')
END
Go

若不存在表数据信息，则删除表

declare
      num number;
begin
    num := 0;--
    select count(1) into num from user_tables where table_name = upper('BDC_FWSX') ;
    if num > 0 then
        execute immediate 'drop table BDC_FWSX' ;
    end if;
    num := 0;--
    select count(1) into num from user_tables where table_name = upper('BDC_ZDXX') ;
    if num > 0 then
        execute immediate 'drop table BDC_ZDXX' ;
    end if;
    num := 0;--
    select count(1) into num from user_tables where table_name = upper('BDC_ZSX') ;
    if num > 0 then
        execute immediate 'drop table BDC_ZSX' ;
    end if;
end;

修改字段列信息

Go
 If exists( SELECT table_name  FROM information_schema.TABLES WHERE table_name ='SyncJob') and not exists(select column_name from information_schema.columns where table_name = 'SyncJob' and column_name = 'CreatedBy')
 ALTER TABLE [SyncJob] ADD [CreatedBy] VARCHAR(50) NOT NULL DEFAULT SUSER_SNAME();
Go
 if exists( SELECT table_name  FROM information_schema.TABLES WHERE table_name ='SyncJob') and not exists(select column_name from information_schema.columns where table_name = 'SyncJob' and column_name = 'CreatedDate')
 ALTER TABLE [SyncJob] ADD [CreatedDate] DateTime NOT NULL DEFAULT GETDATE();