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 (~) | 3474146 |
| Created | 12/13/2017 4:38:50 PM |
| Last Modified | 12/15/2017 12:52:20 PM |
Columns
12| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID_TECO | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| CUIT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| telefono | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| tipodoc | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| documento | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| nombre | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| localidad | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| direccion | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| altura | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| pisodto | varchar | 200 | 0 | 0 | False |
False |
False |
|||||
| CREATED | datetime | 8 | 23 | 3 | True |
(getdate()) | False |
False |
||||
| PROCESADO | bit | 1 | 1 | 0 | True |
(0) | False |
False |
Indexes
1| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
| idx_te_teco_cuit | CUIT | False |
SQL Script
Copy
CREATE TABLE dbo.te_teco2015 (
ID_TECO int IDENTITY,
CUIT varchar(50) NULL,
telefono varchar(200) NULL,
tipodoc varchar(200) NULL,
documento varchar(200) NULL,
nombre varchar(200) NULL,
localidad varchar(200) NULL,
direccion varchar(200) NULL,
altura varchar(200) NULL,
pisodto varchar(200) NULL,
CREATED datetime NOT NULL DEFAULT (getdate()),
PROCESADO bit NOT NULL DEFAULT (0)
)
ON [PRIMARY]
GO
CREATE INDEX idx_te_teco_cuit
ON dbo.te_teco2015 (CUIT)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
ID_TECO int IDENTITY,
CUIT varchar(50) NULL,
telefono varchar(200) NULL,
tipodoc varchar(200) NULL,
documento varchar(200) NULL,
nombre varchar(200) NULL,
localidad varchar(200) NULL,
direccion varchar(200) NULL,
altura varchar(200) NULL,
pisodto varchar(200) NULL,
CREATED datetime NOT NULL DEFAULT (getdate()),
PROCESADO bit NOT NULL DEFAULT (0)
)
ON [PRIMARY]
GO
CREATE INDEX idx_te_teco_cuit
ON dbo.te_teco2015 (CUIT)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
Depends On
1- Fidelitas