Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[MyTable](
- [timestamp] [timestamp] NOT NULL,
- [Col1] [varchar](20) NOT NULL,
- [Col2] [varchar](20) NOT NULL,
- [col3] [datetime] NOT NULL,
- [col4] [varchar](10) NOT NULL,
- [Col5] [varchar](10) NOT NULL,
- [Col6] [varchar](10) NOT NULL,
- [Col7] [decimal](38, 20) NOT NULL,
- [Col8] [decimal](38, 20) NOT NULL,
- [Col9] [datetime] NOT NULL,
- CONSTRAINT [MyTable$0] PRIMARY KEY CLUSTERED
- (
- [Col1] ASC,
- [Col2] ASC,
- [Col3] ASC,
- [Col4] ASC,
- [Col5] ASC,
- [Col6] ASC,
- [Col7] ASC
- ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [Data Filegroup 1]
- ) ON [Data Filegroup 1]
Add Comment
Please, Sign In to add comment