dbo.led_digicard_emp_temp

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 (~) 3904
Created 6/7/2017 6:27:46 PM
Last Modified 6/22/2017 1:58:51 PM

Columns

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

True

False

False

contratista int 4 10 0

True

False

False

empleado int 4 10 0

True

False

False

locaciones varchar 500 0 0

False

False

False

Indexes

1
Key Name Columns Unique Type Description
idxDigiCardEmpTemp1 empleado

False

SQL Script

Copy
CREATE TABLE dbo.led_digicard_emp_temp (
  cliente int NOT NULL,
  contratista int NOT NULL,
  empleado int NOT NULL,
  locaciones varchar(500) NULL
)
ON [PRIMARY]
GO

CREATE INDEX idxDigiCardEmpTemp1
  ON dbo.led_digicard_emp_temp (empleado)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

1
  • Fidelitas