IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE ID = OBJECT_ID('RC_CLI_CONV_DEPENDENTE') AND name = 'CD_CONV')
begin
	ALTER TABLE dbo.RC_CLI_CONV_DEPENDENTE ADD
		CD_CONV int NOT NULL CONSTRAINT DF_RC_CLI_CONV_DEPENDENTE_CD_CONV DEFAULT (0)


	ALTER TABLE dbo.RC_CLI_CONV_DEPENDENTE
		DROP CONSTRAINT PK_RC_CLI_CONV_DEPENDENTE

	ALTER TABLE dbo.RC_CLI_CONV_DEPENDENTE ADD CONSTRAINT
		PK_RC_CLI_CONV_DEPENDENTE PRIMARY KEY CLUSTERED 
		(
		CD_EMP,
		CD_CLI_TITULAR,
		CD_CLI_DEPEND,
		CD_CONV
		) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

END
