1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| CREATE TABLE [dbo].[Dim_Time](
[TimeKey] [int] IDENTITY(1,1) NOT NULL,
[FullDateAlternateKey] [datetime] NOT NULL,
[DayNumberOfWeek] [tinyint] NULL,
[EnglishDayNameOfWeek] [nvarchar](10) NULL,
[SpanishDayNameOfWeek] [nvarchar](10) NULL,
[FrenchDayNameOfWeek] [nvarchar](10) NULL,
[DayNumberOfMonth] [tinyint] NULL,
[DayNumberOfYear] [smallint] NULL,
[WeekNumberOfYear] [tinyint] NULL,
[EnglishMonthName] [nvarchar](10) NULL,
[SpanishMonthName] [nvarchar](10) NULL,
[FrenchMonthName] [nvarchar](10) NULL,
[MonthNumberOfYear] [tinyint] NULL,
[CalendarQuarter] [tinyint] NULL,
[CalendarYear] [char](4) NULL,
[CalendarSemester] [tinyint] NULL,
[FiscalQuarter] [tinyint] NULL,
[FiscalYear] [char](4) NULL,
[FiscalSemester] [tinyint] NULL,
CONSTRAINT [PK_Dim_Time] PRIMARY KEY CLUSTERED
(
[FullDateAlternateKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] |
Partager