name of index need to be unique in database?

They have to be unique for the table or view they were created for.

Here is a reference on Microsoft Learn that details this.

FTA:

index_name

The name of the index. Index names must be unique within a table or view, but don’t have to be unique within a database. Index names must follow the rules of identifiers.

I believe the convention is:

IX_FieldName

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)