dbo.WeekendDates

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 (~) 19722
Created 5/21/2017 12:21:54 AM
Last Modified 5/21/2017 12:21:54 AM

Columns

3
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
d date 3 10 0

True

False

False

isHoliday bit 1 1 0

False

False

False

isWeekend bit 1 1 0

False

False

False

Indexes

1
Key Name Columns Unique Type Description
PK__WeekendD__3BD01989E094865E d

True

SQL Script

Copy
CREATE TABLE dbo.WeekendDates (
  d date NOT NULL,
  isHoliday bit NULL,
  isWeekend bit NULL,
  PRIMARY KEY CLUSTERED (d) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found