dbo.empleados

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 (~)	0
Created	4/25/2021 5:22:18 PM
Last Modified	7/22/2021 10:29:25 PM

Columns

Name	Data Type	Length	Not Null	Computed	Persisted
CUIL	varchar	11	False	False	False
APELLIDOYNOMBRES	varchar	120	False	False	False
FECHADENACIMIENTO	varchar	20	False	False	False
SEXO	varchar	1	False	False	False
CALLE	varchar	100	False	False	False
ALTURA	varchar	10	False	False	False
PISO	varchar	5	False	False	False
DPTO	varchar	5	False	False	False
CP	varchar	4	False	False	False
LOCALIDAD	varchar	100	False	False	False
PROVINCIA	varchar	40	False	False	False
AREA_TEL	varchar	10	False	False	False
TEL	varchar	15	False	False	False
EMAIL	varchar	200	False	False	False
INGRESOS	varchar	20	False	False	False
PERIODO	varchar	4	False	False	False
RECTIFICATIVA	varchar	1	False	False	False
CUITEMP	varchar	11	False	False	False
RAZONSOCIAL	varchar	160	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idxEmpleados2021B	CUIL	False

SQL Script

Copy

CREATE TABLE dbo.empleados_202102B (
  CUIL varchar(11) NULL,
  APELLIDOYNOMBRES varchar(120) NULL,
  FECHADENACIMIENTO varchar(20) NULL,
  SEXO varchar(1) NULL,
  CALLE varchar(100) NULL,
  ALTURA varchar(10) NULL,
  PISO varchar(5) NULL,
  DPTO varchar(5) NULL,
  CP varchar(4) NULL,
  LOCALIDAD varchar(100) NULL,
  PROVINCIA varchar(40) NULL,
  AREA_TEL varchar(10) NULL,
  TEL varchar(15) NULL,
  EMAIL varchar(200) NULL,
  INGRESOS varchar(20) NULL,
  PERIODO varchar(4) NULL,
  RECTIFICATIVA varchar(1) NULL,
  CUITEMP varchar(11) NULL,
  RAZONSOCIAL varchar(160) NULL
)
ON [PRIMARY]
GO

CREATE INDEX idxEmpleados2021B
  ON dbo.empleados_202102B (CUIL)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.empleados_202102B