Remove SQL Azure Data Sync objects manually - Cannot drop schema 'DataSync'

Question

I have done this How to remove SQL Azure Data Sync objects manually but I still have an object I cannot remove

Msg 3729, Level 16, State 1, Line 72 Cannot drop schema 'DataSync' because it is being referenced by object '_TransactionIndex_7c7a43e4-46a5-43b6-8dfb-603c22e00a94_dss_BulkType_c529b2b4-4232-4083-99b3-2240eb2c106e'.

This obetct is with type_desc = TYPE_TABLE but I can't find where to remove it

Dan Guzman · Accepted Answer · 2015-08-17 10:50:48Z

1

Below is example DDL to drop the table type:

DROP TYPE [DataSync].[_TransactionIndex_7c7a43e4-46a5-43b6-8dfb-603c22e00a94_dss_BulkType_c529b2b4-4232-4083-99b3-2240eb2c106e];

answered Aug 17, 2015 at 10:50

Dan Guzman

46.8k3 gold badges52 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sofsntp Over a year ago

nice, thks ! Do you know a place with some knowledge about this ? I'd like to understand a bit more.

Dan Guzman Over a year ago

The SQL Server Books Online is the authoritative references to all T-SQL statments. If you click on the ellipsis to the left of the title DROP TYPE (msdn.microsoft.com/en-us/library/ms174407.aspx) the other DROP statements are listed. Some dependencies "hard", and require dropping objects in dependency order. Others, like dropping a table referenced by a proc, are "soft" dependencies. The referencing object will be broken but the delete is still allowed.

Collectives™ on Stack Overflow

Remove SQL Azure Data Sync objects manually - Cannot drop schema 'DataSync'

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related