Current location - Health Preservation Learning Network - Fitness coach - When using SQL sever, it seems that it is impossible to create multiple clustered indexes on table' C23'. "How to solve?
When using SQL sever, it seems that it is impossible to create multiple clustered indexes on table' C23'. "How to solve?
In SQL server, a table can have at most one clustered index.

By default, the primary key is a clustered index.

So, two ways.

1. Modify the statement in which you created the index and delete the aggregated keyword. This creates a nonclustered index by default.

2. Delete the primary key and regenerate it. When creating a primary key, add the keyword "nonclustered". Then you can create a clustered index.