dbo.codigos_postales

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

False

Full Text Catalog
Full Text
Compression NONE
Row Count (~) 487
Created 2/12/2019 12:46:43 PM
Last Modified 2/12/2019 12:46:43 PM

Columns

3
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
id_codigo_postal int 4 10 0

True

1 - 1

False

False

codigo_postal varchar 50 0 0

True

False

False

localidad_asociada varchar 200 0 0

True

False

False

Indexes

1
Key Name Columns Unique Type Description
PK__codigos___330E72944C525958 id_codigo_postal

True

SQL Script

Copy
CREATE TABLE dbo.codigos_postales (
  id_codigo_postal int IDENTITY,
  codigo_postal varchar(50) NOT NULL,
  localidad_asociada varchar(200) NOT NULL,
  PRIMARY KEY CLUSTERED (id_codigo_postal) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

1
  • Fidelitas

Used By

No items found