1
0

002_EstateStore.sql 814 B

12345678910111213141516171819202122232425
  1. BEGIN TRANSACTION
  2. ALTER TABLE dbo.estate_managers DROP CONSTRAINT PK_estate_managers
  3. CREATE NONCLUSTERED INDEX IX_estate_managers ON dbo.estate_managers
  4. (
  5. EstateID
  6. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  7. ALTER TABLE dbo.estate_groups DROP CONSTRAINT PK_estate_groups
  8. CREATE NONCLUSTERED INDEX IX_estate_groups ON dbo.estate_groups
  9. (
  10. EstateID
  11. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  12. ALTER TABLE dbo.estate_users DROP CONSTRAINT PK_estate_users
  13. CREATE NONCLUSTERED INDEX IX_estate_users ON dbo.estate_users
  14. (
  15. EstateID
  16. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  17. COMMIT