dbo.padron

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 (~)	15542140
Created	7/29/2020 6:48:54 PM
Last Modified	1/29/2023 11:08:38 AM

Columns

Key	Name	Data Type	Length	Not Null	Computed	Persisted
	RUC	varchar	50	False	False	False
2	NOMBRE	varchar	250	False	False	False
	ESTADO	varchar	50	False	False	False
	CONDICIONDEDOMICILIO	varchar	50	False	False	False
	UBIGEO	varchar	50	False	False	False
	TIPODEVIA	varchar	50	False	False	False
	NOMBREDEVIA	varchar	50	False	False	False
	CODIGODEZONA	varchar	50	False	False	False
	TIPODEZONA	varchar	50	False	False	False
	NUMERO	varchar	50	False	False	False
	INTERIOR	varchar	50	False	False	False
	LOTE	varchar	50	False	False	False
	DEPARTAMENTO	varchar	50	False	False	False
	MANZANA	varchar	50	False	False	False
	KILOMETRO	varchar	50	False	False	False
	Column15	varchar	50	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idpadronperu	NOMBRE	False
	idpadronperu012023	NOMBRE	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

CREATE INDEX idpadronperu
  ON dbo.padron_peru (NOMBRE)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idpadronperu012023
  ON dbo.padron_peru (NOMBRE)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

dbo.peru_worldsys_data