DECLARE @sSql VARCHAR(200)
DECLARE @PK_Customer VARCHAR(100)
IF EXISTS(SELECT NAME FROM syscolumns WHERE Name = 'ProdCode' AND id = OBJECT_ID('tProduct') AND length <> 30)
BEGIN
  SELECT @PK_Customer = NAME FROM sysobjects 
  WHERE xtype = 'PK' and parent_obj = OBJECT_ID('tProduct')
  IF @PK_Customer IS NOT NULL 
    EXEC('ALTER TABLE tProduct DROP CONSTRAINT ' + @PK_Customer)
  EXEC('ALTER TABLE tProduct ALTER COLUMN ProdCode VARCHAR(30) NOT NULL ')
  EXEC('ALTER TABLE tProduct ADD CONSTRAINT PK_tProduct PRIMARY KEY([ProdCode]) ON [PRIMARY] ')  
END 
IF NOT EXISTS(SELECT NAME FROM sysobjects WHERE xtype = 'PK' and parent_obj = OBJECT_ID('tProduct'))
  EXEC('ALTER TABLE tProduct ADD CONSTRAINT PK_tProduct PRIMARY KEY([ProdCode]) ON [PRIMARY] ')  