常用SQL 语句

--Delte primary key of Condition

alter table Condition drop constraint PK__Conditio__3214EC0700DF2177;

--Add Primary key for Condition

alter table Condition add constraint PK__Conditio__3214EC0700DF2177 primary key NONCLUSTERED(Id);

 

--Drop column PatientPSI_Id

Alter table Condition drop column PatientPSI_Id;

--Add column Condition_Id for PatientPSI

alter table PatientPSI add Condition_Id nvarchar(36) not null foreign key references Condition(Id);

 

--Add foreign Key

alter table ConditionMedication add constraint

FK_ConditionMedication_Condition_ConditionId foreign key (Condition_Id)

references Condition(Id);