asgag

/**************************************************/
PRINT 'dbo.Server - PK';
/**************************************************/
SET ANSI_NULLS ON;
SET NOCOUNT ON;
SET QUOTED_IDENTIFIER OFF;
SET XACT_ABORT ON;

/**************************************************
Delete PK
**************************************************/
IF OBJECT_ID('dbo.Server_PK') IS NOT NULL
BEGIN
    /**************************************************/
    PRINT CHAR(9) + 'dropping FKs';
    /**************************************************/
    EXEC sp_dba_Table_DropPK
        @aSPMode    = 1
    ,   @aTableName = 'dbo.Server'
    ;
    /**************************************************/
    PRINT CHAR(9) + 'dropping PK';
    /**************************************************/
    ALTER TABLE dbo.Server DROP CONSTRAINT Server_PK;
END

/**************************************************/
PRINT CHAR(9) + 'Creating PK';
/**************************************************/
GO

ALTER TABLE dbo.Server ADD
    CONSTRAINT Server_PK PRIMARY KEY CLUSTERED
    (
        ServerID
    )
;

GO