KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am writing this a follow up to Changing data type of column in SQL Server My question earlier was if I need to remove all indexes and constraints and it was answered I do need to remove them. So as I was surf internet on the topic I came across a few post saying its better to disable and enable an index, rather than removing and recreating them . So which is better way of doing it? Does disabling of index allow you to change the data type of the column as well? What is the difference between both? Statement with dropping and creating index DROP INDEX UX_1_COMPUTATION ON dbo.Computation ALTER TABLE dbo.Computation ALTER COLUMN ComputationID NVARCHAR(25) not null CREATE UNIQUE INDEX UX_1_COMPUTATION ON dbo.Computation (ComputationID); Statement with disabling and enabling index ALTER INDEX [UX_1_COMPUTATION ] ON dbo.Computation DISABLE ALTER TABLE dbo.Computation ALTER COLUMN ComputationID NVARCHAR(25) not null ALTER INDEX [UX_1_COMPUTATION ] ON dbo.Computation REBUILD;
Tags (comma-separated)
Save Edits
Cancel