sql - Clustered Index Error in Azure for a Table that Has a Clustered Index -

i running command on sql azure.

delete dbo.users 

i getting error.

msg 40054, level 16, state 1, line 1
tables without clustered index not supported in version of sql server. please create clustered index , try again.

i try create clustered index.

create unique clustered index idx_users on dbo.users(id); 

i error.

msg 1902, level 16, state 3, line 4
cannot create more 1 clustered index on table 'dbo.users'. drop existing clustered index 'pk_dbo.users' before creating another.

do or not have clustered index?

i had similar issue unable delete records table.

after reading post, sql azure not recognizing clustered index, paired post checked dependencies through mssms on security_user table; 0-n relationship table, security_userhistory, had fk-reference table. reference not indexed , (strangely enough) triggered error in question.

after applying clustered index fk-table security_userhistory referencing pk-table security_user problem solved.

i wish microsoft add clarity in error message, indicates problem lies table deleting rows from.