dbo.cendeu_cancela

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	6884
Created	8/26/2016 10:01:17 AM
Last Modified	6/22/2017 1:30:53 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_cendeu_cancela	int	4	10	0	True	1 - 1	False	False
iden	varchar	11	0	0	False		False	False
codigo_ent	int	4	10	0	False		False	False
fec_inf_desde	smalldatetime	4	16	0	False		False	False
fec_inf_hasta	smalldatetime	4	16	0	False		False	False
eve_codigo	varchar	10	0	0	False		False	False
fecha	date	3	10	0	False		False	False
fue_codigo	varchar	10	0	0	False		False	False
fecha_fuente	date	3	10	0	False		False	False
observaciones	varchar		0	0	False		False	False
vigente	bit	1	1	0	False		False	False
id_persona	int	4	10	0	False		False	False
created_by	int	4	10	0	False		False	False
created	datetime	8	23	3	False		False	False
modified_by	int	4	10	0	False		False	False
modified	datetime	8	23	3	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idx_cendeu_cancela	iden, codigo_ent, vigente, fec_inf_desde, fec_inf_hasta	False

SQL Script

Copy

CREATE TABLE dbo.cendeu_cancela (
  id_cendeu_cancela int IDENTITY,
  iden varchar(11) NULL,
  codigo_ent int NULL,
  fec_inf_desde smalldatetime NULL,
  fec_inf_hasta smalldatetime NULL,
  eve_codigo varchar(10) NULL,
  fecha date NULL,
  fue_codigo varchar(10) NULL,
  fecha_fuente date NULL,
  observaciones varchar(max) NULL,
  vigente bit NULL,
  id_persona int NULL,
  created_by int NULL,
  created datetime NULL,
  modified_by int NULL,
  modified datetime NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idx_cendeu_cancela
  ON dbo.cendeu_cancela (iden, codigo_ent, vigente, fec_inf_desde, fec_inf_hasta)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas