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 | 3/6/2025 6:55:54 PM |
| Last Modified | 3/6/2025 6:55:54 PM |
Columns
16| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RUC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NOMBRE | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| ESTADO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CONDICIONDEDOMICILIO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| UBIGEO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TIPODEVIA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NOMBREDEVIA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CODIGODEZONA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TIPODEZONA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NUMERO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| INTERIOR | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| LOTE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DEPARTAMENTO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| MANZANA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| KILOMETRO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column15 | varchar | 50 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.padron_peru (
RUC varchar(50) NULL,
NOMBRE varchar(250) NULL,
ESTADO varchar(50) NULL,
CONDICIONDEDOMICILIO varchar(50) NULL,
UBIGEO varchar(50) NULL,
TIPODEVIA varchar(50) NULL,
NOMBREDEVIA varchar(50) NULL,
CODIGODEZONA varchar(50) NULL,
TIPODEZONA varchar(50) NULL,
NUMERO varchar(50) NULL,
INTERIOR varchar(50) NULL,
LOTE varchar(50) NULL,
DEPARTAMENTO varchar(50) NULL,
MANZANA varchar(50) NULL,
KILOMETRO varchar(50) NULL,
Column15 varchar(50) NULL
)
ON [PRIMARY]
GO
RUC varchar(50) NULL,
NOMBRE varchar(250) NULL,
ESTADO varchar(50) NULL,
CONDICIONDEDOMICILIO varchar(50) NULL,
UBIGEO varchar(50) NULL,
TIPODEVIA varchar(50) NULL,
NOMBREDEVIA varchar(50) NULL,
CODIGODEZONA varchar(50) NULL,
TIPODEZONA varchar(50) NULL,
NUMERO varchar(50) NULL,
INTERIOR varchar(50) NULL,
LOTE varchar(50) NULL,
DEPARTAMENTO varchar(50) NULL,
MANZANA varchar(50) NULL,
KILOMETRO varchar(50) NULL,
Column15 varchar(50) NULL
)
ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found