Guest User

Untitled

a guest
Jul 15th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. CREATE TABLE [dbo].[MyTable](
  2. [timestamp] [timestamp] NOT NULL,
  3. [Col1] [varchar](20) NOT NULL,
  4. [Col2] [varchar](20) NOT NULL,
  5. [col3] [datetime] NOT NULL,
  6. [col4] [varchar](10) NOT NULL,
  7. [Col5] [varchar](10) NOT NULL,
  8. [Col6] [varchar](10) NOT NULL,
  9. [Col7] [decimal](38, 20) NOT NULL,
  10. [Col8] [decimal](38, 20) NOT NULL,
  11. [Col9] [datetime] NOT NULL,
  12. CONSTRAINT [MyTable$0] PRIMARY KEY CLUSTERED
  13. (
  14. [Col1] ASC,
  15. [Col2] ASC,
  16. [Col3] ASC,
  17. [Col4] ASC,
  18. [Col5] ASC,
  19. [Col6] ASC,
  20. [Col7] ASC
  21. ) 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]
  22. ) ON [Data Filegroup 1]
Add Comment
Please, Sign In to add comment