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 = @sch AND 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) NULL ALTER TABLE formadeliquidacao ADD CONSTRAINT pk_formadeliquidacao PRIMARY KEY(id); END

formadeliquidação

Download PDF Report

Upload
tiago-luis
View
227
Download
0

Embed Size (px)

Citation preview

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