×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Trần Hải Quân
Added: Jul 17, 2013 2:51 AM
Modified: Jul 17, 2013 2:52 AM
Views: 1814
Tags: sql
  1. CREATE NONCLUSTERED INDEX [idx_map] ON [dbo].[MapID]
  2. (
  3.         [OldId] ASC,
  4.         [NewId] ASC,
  5.         [TableName] ASC
  6. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
  7. GO
  8.  
  9. CREATE NONCLUSTERED INDEX [idx_tablename] ON [dbo].[MapID]
  10. (
  11.         [TableName] ASC
  12. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
  13. GO
  14.  
  15.  
  16.  
  17. ALTER TABLE [dbo].[MapID] ADD  CONSTRAINT [PK_MapID] PRIMARY KEY CLUSTERED
  18. (
  19.         [Id] ASC
  20. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
  21. GO
  22.  
  23.  
  24.