7/23/2019 formadeliquidação

http://slidepdf.com/reader/full/formadeliquidacao 1/1

 DECLARE @sch AS SYSNAME

SET @sch = 'dbo'

IF NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = @schAND TABLE_NAME = 'formadeliquidacao')BEGIN

 

CREATE TABLE formadeliquidacao(id bigint NOT NULL,descricao varchar(20) NOT NULL,codigoexterno varchar(20) NULL,desabilitado bit NULL,tipo varchar(255) NULL,version bigint NULL,codigobacen varchar(10) NULLALTER TABLE formadeliquidacao ADD CONSTRAINT pk_formadeliquidacaoPRIMARY KEY(id);

 

END