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 (~) | 20379 |
| Created | 5/26/2024 4:20:01 PM |
| Last Modified | 5/26/2024 5:10:12 PM |
Columns
15| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FECHAINICIODEMANDA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ACTOR | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| EXPEDIENTE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CARATULA | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| JUZGADO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| SECRETARIA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ANIO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DEMANDADO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| OBJETO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| auxexpediente | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| idlote | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| mes | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| dia | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| anio_fechainicio | varchar | 4 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo._A_juicios_BT_txt (
ID varchar(50) NULL,
FECHAINICIODEMANDA varchar(50) NULL,
ACTOR varchar(150) NULL,
EXPEDIENTE varchar(50) NULL,
CARATULA varchar(250) NULL,
JUZGADO varchar(150) NULL,
SECRETARIA varchar(50) NULL,
ANIO varchar(50) NULL,
DEMANDADO varchar(150) NULL,
OBJETO varchar(150) NULL,
auxexpediente varchar(50) NULL,
idlote varchar(50) NULL,
mes varchar(2) NULL,
dia varchar(2) NULL,
anio_fechainicio varchar(4) NULL
)
ON [PRIMARY]
GO
ID varchar(50) NULL,
FECHAINICIODEMANDA varchar(50) NULL,
ACTOR varchar(150) NULL,
EXPEDIENTE varchar(50) NULL,
CARATULA varchar(250) NULL,
JUZGADO varchar(150) NULL,
SECRETARIA varchar(50) NULL,
ANIO varchar(50) NULL,
DEMANDADO varchar(150) NULL,
OBJETO varchar(150) NULL,
auxexpediente varchar(50) NULL,
idlote varchar(50) NULL,
mes varchar(2) NULL,
dia varchar(2) NULL,
anio_fechainicio varchar(4) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found