EN
MS SQL Server - remove index from existing table link---
0 points
TODO: index na końcu
In this article, we would like to show you how to remove an index from the existing table in MS SQL Server.
Quick solution:
xxxxxxxxxx1
ALTER TABLE [table_name]2
DROP INDEX [index_name];or
xxxxxxxxxx1
DROP INDEX [index_name] ON [table_name];In this example, we will remove the salary_index created in the previous article.
Query:
xxxxxxxxxx1
ALTER TABLE [users]2
DROP INDEX [salary_index];or
xxxxxxxxxx1
DROP INDEX [salary_index] ON [users];