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:21:06 PM |
| Last Modified | 4/25/2021 5:21:06 PM |
Columns
19| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUIL | varchar | 11 | 0 | 0 | False |
False |
False |
|||||
| APELLIDOYNOMBRES | varchar | 120 | 0 | 0 | False |
False |
False |
|||||
| FECHADENACIMIENTO | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| SEXO | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| CALLE | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| ALTURA | varchar | 10 | 0 | 0 | False |
False |
False |
|||||
| PISO | varchar | 5 | 0 | 0 | False |
False |
False |
|||||
| DPTO | varchar | 5 | 0 | 0 | False |
False |
False |
|||||
| CP | varchar | 4 | 0 | 0 | False |
False |
False |
|||||
| LOCALIDAD | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| PROVINCIA | varchar | 40 | 0 | 0 | False |
False |
False |
|||||
| AREA_TEL | varchar | 10 | 0 | 0 | False |
False |
False |
|||||
| TEL | varchar | 15 | 0 | 0 | False |
False |
False |
|||||
| varchar | 200 | 0 | 0 | False |
False |
False |
||||||
| INGRESOS | varchar | 8 | 0 | 0 | False |
False |
False |
|||||
| PERIODO | varchar | 4 | 0 | 0 | False |
False |
False |
|||||
| RECTIFICATIVA | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| CUITEMP | varchar | 11 | 0 | 0 | False |
False |
False |
|||||
| RAZONSOCIAL | varchar | 160 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.empleados_202102 (
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(8) NULL,
PERIODO varchar(4) NULL,
RECTIFICATIVA varchar(1) NULL,
CUITEMP varchar(11) NULL,
RAZONSOCIAL varchar(160) NULL
)
ON [PRIMARY]
GO
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(8) NULL,
PERIODO varchar(4) NULL,
RECTIFICATIVA varchar(1) NULL,
CUITEMP varchar(11) NULL,
RAZONSOCIAL varchar(160) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found