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
Comments
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎
0 B
|👍
/👎