dbo.cendeu_bloqueo

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 (~)	66900
Created	8/26/2016 10:02:09 AM
Last Modified	6/28/2018 11:18:24 AM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_cendeu_bloqueo	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_hasta	smalldatetime	4	16	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
proceso_previo	bit	1	1	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idx_cendeu_bloqueo_fec	fec_inf_hasta	False

SQL Script

Copy

CREATE TABLE dbo.cendeu_bloqueo (
  id_cendeu_bloqueo int IDENTITY,
  iden varchar(11) NULL,
  codigo_ent int NULL,
  fec_inf_hasta smalldatetime 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,
  proceso_previo bit NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idx_cendeu_bloqueo_fec
  ON dbo.cendeu_bloqueo (fec_inf_hasta)
  INCLUDE (iden, codigo_ent)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas