IF NOT EXISTS (SELECT * FROM SYS.OBJECTS WHERE NAME  = 'EST_PROD_PRECO_PMPF_CPL_N_ENC')
BEGIN 
	CREATE TABLE  EST_PROD_PRECO_PMPF_CPL_N_ENC (
		CD_CTR		 INT			NOT NULL,
		EAN			 VARCHAR (50)	COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NOT NULL,
		DS_PROD		 VARCHAR (100)	COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS,
		VLR_PMPF	 MONEY			NULL,
		LABORATORIO  VARCHAR (150)	COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS,
		APRESENTACAO VARCHAR (150)	COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS,
		CONSTRAINT PK_EST_PROD_PRECO_PMPF_CPL_N_ENC  PRIMARY KEY  (CD_CTR,EAN), 
		CONSTRAINT FK_EST_PROD_PRECO_PMPF_CPL_N_ENC_CD_CTR FOREIGN KEY (CD_CTR) REFERENCES EST_PROD_PRECO_PMPF (CD_CTR)
		)

END 