21 lines
525 B
Transact-SQL
21 lines
525 B
Transact-SQL
CREATE TABLE [dbo].[CRT_LastQuote] (
|
|
[TableName] VARCHAR (20) NULL,
|
|
[CRTD_PairSymbol] VARCHAR (50) NULL,
|
|
[LAST_CRTD_Period] DATETIME NULL,
|
|
[NEXT_CRTD_Period] DATETIME NULL,
|
|
[Next_End_period] DATETIME NULL,
|
|
[LastQuote] DATETIME NULL,
|
|
[ExchangeId] INT NOT NULL
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [ix_TableName]
|
|
ON [dbo].[CRT_LastQuote]([TableName] ASC);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [ix_CRTD_PairSymbol]
|
|
ON [dbo].[CRT_LastQuote]([CRTD_PairSymbol] ASC);
|
|
|