asga1214

/**************************************************/
PRINT 'dbo.ServerDrive - Keys';
/**************************************************/
SET ANSI_NULLS ON;
SET NOCOUNT ON;
SET QUOTED_IDENTIFIER OFF;

/**************************************************/
PRINT CHAR(9) + 'dropping FKs';
/**************************************************/
EXEC sp_dba_Table_DropFK
	@aSPMode	= 1
,	@aDirection	= 'OUT'
,	@aTableName = 'dbo.ServerDrive'
;

/**************************************************/
PRINT CHAR(9) + 'creating FKs';
/**************************************************/
ALTER TABLE dbo.ServerDrive ADD
	CONSTRAINT ServerDrive_Server_FK FOREIGN KEY (
		ServerID
	) REFERENCES dbo.Server (
		ServerID
	)
;

GO