dbo.led_compliance

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 (~) 502374
Created 12/29/2015 4:57:46 PM
Last Modified 8/5/2017 11:16:31 PM

Columns

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

True

False

False

periodo int 4 10 0

True

False

False

led_seccion varchar 1 0 0

True

False

False

estado_compliance varchar 1 0 0

False

False

False

Indexes

1
Key Name Columns Unique Type Description
XPKled_compliance periodo, contratista, led_seccion

True

SQL Script

Copy
CREATE TABLE dbo.led_compliance (
  contratista int NOT NULL,
  periodo int NOT NULL,
  led_seccion varchar(1) NOT NULL,
  estado_compliance varchar(1) NULL,
  CONSTRAINT XPKled_compliance PRIMARY KEY NONCLUSTERED (periodo, contratista, led_seccion) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

Depends On

1
  • Fidelitas