forked from aravindsuri/ADFTutorial
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathstage.Sales.Table.sql
More file actions
21 lines (21 loc) · 1.12 KB
/
Copy pathstage.Sales.Table.sql
File metadata and controls
21 lines (21 loc) · 1.12 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
USE [WineStoreDW]
GO
/****** Object: Table [stage].[Sales] Script Date: 9/15/2022 9:22:29 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [stage].[Sales](
[ProductNo] [nvarchar] (50) NOT NULL,
[OnlineRetailer] [nvarchar] (20) NULL,
[SalesMonth] [nvarchar] (12) NULL,
[SalesTerritory] [nvarchar] (2) NULL,
[SalesCurrency] [nvarchar] (3) NULL,
[Title] [nvarchar] (255) NULL,
[Vintage] [int] NULL,
[Variety] [nvarchar] (50) NULL,
[Score] [int] NULL,
[ListPrice] [int] NULL,
[Quantity] [int] NULL
) ON [PRIMARY]
GO