- Subject
- Untitled
- Author
- Unnamed
- Description
- No description given
- Posted on
- Tue, 24 Aug 2010 14:26:52 +0200
- Content
-
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE
[dbo].[Data_Asset_Price_2](
[DT] [datetime] NOT NULL,
[Asset_ID] [varchar](50) NOT NULL,
[Asset_Type]
[varchar](50) NOT NULL,
[Price_Ccy] [varchar](50) NOT NULL,
[Price] [float] NOT NULL,
[Unit] [int] NOT
NULL,
[Load_UID] [uniqueidentifier] NULL,
[Msg_UID] [uniqueidentifier] NULL,
[Insert_Date] [datetime] NOT NULL
CONSTRAINT [DF_Data_Asset_Price_Insert_Date] DEFAULT (getdate()),
CONSTRAINT [PK_Data_Asset_Price_2] PRIMARY KEY
(
[DT] ASC,
[Asset_ID] 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
SET ANSI_PADDING OFF