  IF NOT EXISTS (SELECT * FROM SYS.OBJECTS WHERE OBJECT_ID = OBJECT_ID(N'LOG_AUDIT_CONCILIADOR') AND TYPE IN (N'U'))
BEGIN
CREATE TABLE  LOG_AUDIT_CONCILIADOR (
	 CD_CTR 			 BIGINT  IDENTITY(1,1) NOT NULL,
	 DT_LOG 			 DATETIME  NOT NULL,
	 DESCR_MENSAGEM 	 VARCHAR (500) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS  NULL,
	 DESCR_ERRO 		 VARCHAR (500) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS  NULL,
	 DESCR_DETALHE 		 VARCHAR (500) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS  NULL,
	 ST_ERRO 			 INT  NOT NULL,
	 IDT_PROCESSO 		 VARCHAR (500) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS  NOT NULL,
	 DESCR_PROCESSO 	 VARCHAR (6)   COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS  NOT NULL,
 CONSTRAINT  PK_LOG_AUDIT_CONCILIADOR  PRIMARY KEY CLUSTERED 
(
	 CD_CTR  ASC
)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 98)  
)  
end 
 


 