IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'titular'))
BEGIN

CREATE TABLE [dbo].[titular](
	[IDTITULAR] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,
	[idvida] [bigint] NULL,
	[plano] [varchar](120) NULL,
	[nome] [varchar](120) NULL,
	[nascimento] [date] NULL,
	[CGCCPF] [varchar](18) NULL,
	[certificado] [varchar](30) NULL,
	[matricula] [varchar](30) NULL,
	[capital] [numeric](12, 2) NULL,
	[premio] [numeric](8, 2) NULL,
	[usuariocriacao] [bigint] NULL,
	[usuarioalteracao] [bigint] NULL,
	[datacriacao] [datetime] NULL,
	[dataalteracao] [datetime] NULL,
	[idtitularcopiado] [bigint] NULL,
	[saida] [date] NULL,
	[obs] [varchar](max) NULL,
	[RG] [varchar](13) NULL,
	[emissao] [date] NULL,
	[rguf] [varchar](2) NULL,
	[entrada] [date] NULL);

END

