DimDates_Create_DDL.sql

CREATE TABLE [dbo].[DimDates] (
    [DateID] [INT] NOT NULL,
    [Date] [DATE] NULL,
    [NextDayDate] [DATE] NULL,
    [CalendarYear] [INT] NULL,
    [CalendarYearQuarter] [INT] NULL,
    [CalendarYearMonth] [INT] NULL,
    [CalendarYearDayOfYear] [INT] NULL,
    [CalendarQuarter] [TINYINT] NULL,
    [CalendarMonth] [TINYINT] NULL,
    [CalendarDayOfYear] [INT] NULL,
    [CalendarDayOfMonth] [TINYINT] NULL,
    [CalendarDayOfWeek] [TINYINT] NULL,
    [CalendarYearName] [VARCHAR](4) NULL,
    [CalendarYearQuarterName] [VARCHAR](7) NULL,
    [CalendarYearMonthName] [VARCHAR](8) NULL,
    [CalendarYearMonthNameLong] [VARCHAR](14) NULL,
    [CalendarQuarterName] [VARCHAR](2) NULL,
    [CalendarMonthName] [VARCHAR](3) NULL,
    [CalendarMonthNameLong] [VARCHAR](9) NULL,
    [WeekdayName] [VARCHAR](3) NULL,
    [WeekdayNameLong] [VARCHAR](9) NULL,
    [QuarterSeqNo] [INT] NULL,
    [MonthSeqNo] [INT] NULL,
    [ISODate] [CHAR](10) NULL,
    [ISOYearWeekNumber] [INT] NULL,
    [ISOWeekNumber] [TINYINT] NULL,
    [ISODayOfWeek] [TINYINT] NULL,
    [ISOYearWeekName] [CHAR](8) NULL,
    [DateFormatYYYY_MM_DD] [CHAR](10) NULL,
    [DateFormatYYYY_M_D] [VARCHAR](10) NULL,
    [DateFormatMM_DD_YYYY] [CHAR](10) NULL,
    [DateFormat_M_DYYYY] [VARCHAR](10) NULL,
    [DateFormat_MMM_D_YYYY] [VARCHAR](20) NULL,
    [DateFormat_Month_D_YYYY] [VARCHAR](20) NULL,
    [DateFormat_MM_DD_YY] [CHAR](8) NULL,
    [DateFormat_M_D_YY] [VARCHAR](8) NULL,
    [CalendarStartOfYearDate] [DATE] NULL,
    [CalendarEndOfYearDate] [DATE] NULL,
    [CalendarStartOfQuarterDate] [DATE] NULL,
    [CalendarEndOfQuarterDate] [DATE] NULL,
    [CalendarStartOfMonthDate] [DATE] NULL,
    [CalendarEndOfMonthDate] [DATE] NULL,
    [StartOfWeekStartingSunDate] [DATE] NULL,
    [EndOfWeekStartingSunDate] [DATE] NULL,
    [StartOfWeekStartingMonDate] [DATE] NULL,
    [EndOfWeekStartingMonDate] [DATE] NULL,
 CONSTRAINT [PK_DimDates] PRIMARY KEY CLUSTERED
(
    [DateID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO