azure - Deprecated feature 'DROP INDEX with two-part name' is not supported in this version of SQL Server -
i using query delete indexer table in sql azure
drop index [dbo].[visulaization_unitusermapping].ix_visulaization_unitusermapping_unituserid;
but getting error : deprecated feature 'drop index two-part name' not supported in version of sql server.
is there other way done in sql azure
you drop index using following syntax:
drop index ix_visulaization_unitusermapping_unituserid on [dbo].[visulaization_unitusermapping]
i.e.
drop index indexname on schemaname.tablename
ref.: drop index
Comments
Post a Comment