- Explore
- Collaborate
- Visualize
- Connect
- Pricing
How to Drop an Index in SQL Server
To drop a non-primary key index, use the DROP INDEX
command:
-- syntax
drop index table_name.index_name;
drop index products.products_category;
To drop a primary key index, use the ALTER TABLE .. DROP CONSTRAINT
command :
alter table products
drop constraint pk_products;
From SQL Server query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and SQL Server
Previous
How to Create an Index
From SQL Server query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and SQL Server