SQL 删除或修改

1.删除外键

if   exists   (select   *   from   dbo.sysobjects   where   id   =   object_id(N'[dbo].[D_FK]')   and   OBJECTPROPERTY(id,   N'IsForeignKey')   =   1)  
  ALTER   TABLE   [dbo].[D]   DROP   CONSTRAINT   D_FK  

 

2.删除索引

IF EXISTS (SELECT [NAME] FROM sysindexes  WHERE name = 'IX_RMSORGANIZATION')  
  DROP INDEX IX_RMSORGANIZATION ON dbo.RmsOrganization

 

3.删除主键

IF OBJECT_ID('PK_RMSORGANIZATION','PK') IS NOT NULL
 ALTER TABLE dbo.RmsOrganization DROP CONSTRAINT PK_RMSORGANIZATION

 

4.删除表

if exists(select * from sysobjects where name='RmsConfig')
drop table RmsConfig

 

5.修改表添加字段
if not exists (select 1 from syscolumns where id=object_id('RmsActivity') and name='UnitCode')
alter table RmsActivity add UnitCode nvarchar(50)

 

6.添加主键

alter table RmsOrganization alter column UnitCode nvarchar(50)  not  null  

7.给主键赋固定值

alter table RmsOrganization add constraint [PK_RmsOrganization] primary key clustered (UnitCode) on [primary]