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