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 (~) | 16099 |
| Created | 3/5/2022 12:02:26 PM |
| Last Modified | 3/5/2022 12:02:26 PM |
Columns
11| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CERTIF | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ESTRENT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CODBCO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TIPDOC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NRODOC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NOMBRE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| ANONAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| MESNAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DIANAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SEXO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL | varchar | 50 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.la_estrella_base (
[CERTIF ] varchar(50) NULL,
ESTRENT varchar(50) NULL,
CODBCO varchar(50) NULL,
[TIPDOC ] varchar(50) NULL,
[NRODOC ] varchar(50) NULL,
NOMBRE varchar(150) NULL,
ANONAC varchar(50) NULL,
MESNAC varchar(50) NULL,
DIANAC varchar(50) NULL,
SEXO varchar(50) NULL,
CUIL varchar(50) NULL
)
ON [PRIMARY]
GO
[CERTIF ] varchar(50) NULL,
ESTRENT varchar(50) NULL,
CODBCO varchar(50) NULL,
[TIPDOC ] varchar(50) NULL,
[NRODOC ] varchar(50) NULL,
NOMBRE varchar(150) NULL,
ANONAC varchar(50) NULL,
MESNAC varchar(50) NULL,
DIANAC varchar(50) NULL,
SEXO varchar(50) NULL,
CUIL varchar(50) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found