USE [envisage]

if exists (select * from sys.all_objects where name like 'PK_FiscalYear' and parent_object_id = OBJECT_ID('FiscalYear') and type = 'PK')
begin
	ALTER TABLE dbo.FiscalYear DROP CONSTRAINT PK_FiscalYear
end

ALTER TABLE dbo.FiscalYear ADD CONSTRAINT
	PK_FiscalYear PRIMARY KEY CLUSTERED 
	(
	Id
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO