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 (~) | 16070 |
| Created | 12/3/2021 4:43:56 PM |
| Last Modified | 12/5/2021 7:33:36 PM |
Columns
13| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CERTIF | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| EST_RENT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| COD | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TIP_DOC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NRO_DOC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NOMBRE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| ANO_NAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| MES_NAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DIA_NAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SEXO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| fecha_fallecimiento | date | 3 | 10 | 0 | False |
False |
False |
|||||
| cuil_original | varchar | 30 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.estrella_DIC_2021_AGB (
CERTIF varchar(50) NULL,
EST_RENT varchar(50) NULL,
COD varchar(50) NULL,
TIP_DOC varchar(50) NULL,
NRO_DOC varchar(50) NULL,
NOMBRE varchar(150) NULL,
ANO_NAC varchar(50) NULL,
MES_NAC varchar(50) NULL,
DIA_NAC varchar(50) NULL,
SEXO varchar(50) NULL,
CUIL varchar(50) NULL,
fecha_fallecimiento date NULL,
cuil_original varchar(30) NULL
)
ON [PRIMARY]
GO
CERTIF varchar(50) NULL,
EST_RENT varchar(50) NULL,
COD varchar(50) NULL,
TIP_DOC varchar(50) NULL,
NRO_DOC varchar(50) NULL,
NOMBRE varchar(150) NULL,
ANO_NAC varchar(50) NULL,
MES_NAC varchar(50) NULL,
DIA_NAC varchar(50) NULL,
SEXO varchar(50) NULL,
CUIL varchar(50) NULL,
fecha_fallecimiento date NULL,
cuil_original varchar(30) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found