All Questions
8 questions
3
votes
3
answers
269
views
How can I know how many tables my DELETE has changed?
Suppose that I have many tables linked by a chain of ON DELETE CASCADE foreign keys. To the best of my knowledge and experience, deleting from one table gives me no notice at all that I have in fact ...
- 855
3
votes
5
answers
13k
views
Disadvantages to using ON DELETE CASCADE on every foreign key?
Our application currently has "soft delete" built-in to most tables with a BIT "deleted" column.
There is now a requirement for "hard delete" functionality.
Are there any ...
- 259
2
votes
1
answer
3k
views
Introducing FOREIGN KEY constraint 'FK_X_Y' on table 'X' may cause cycles or multiple cascade paths
So while publishing my database scripts in Visual Studio, I get this exact error: Introducing FOREIGN KEY constraint 'FK_Users_Manager' on table 'Users' may cause cycles or multiple cascade paths. ...
5
votes
2
answers
10k
views
Solving ON DELETE CASCADE cycles with triggers on MS SQL Server
I have code that is working fine in PostgreSQL and I now have to port it to MS SQL Server. It involves tables with potential cycles on delete/update events and SQL Server is complaining about it:
-- ...
- 239
1
vote
2
answers
810
views
Simulate DELETE CASCADE
I need to delete many rows from one table persons, that is referenced by many other tables as FK.
If I had DELETE CASCADE, I could just delete the records from persons, and automatically delete from ...
- 1,497
4
votes
1
answer
2k
views
Is there a possibility to see cascade path in MS SQL
I'm having trouble with creating a foreign key in a database, because of multiple cascade paths.
I am aware of some of my FKs cascading the delete, but I cannot traverse back to find the multiple ...
- 141
4
votes
1
answer
1k
views
Soft ON DELETE CASCADE
I am familiar with the ON DELETE CASCADE method, but I don't want to do a real delete, just a soft delete. This is implemented with a column named isDeleted (0/1).
Is there a way for me to cascade ...
- 41
2
votes
1
answer
1k
views
Several Foreign Key and Cascade Delete SQL Server
In SQL Server 2014, I'm trying to add CASCADE DELETING (I want to set field to null actually, but is the same ) on 3 FK. If I add a Cascade Delete in one relationship, it works fine. If I add more ...
- 123