/SQL/Sql truncate table referencing itself

Sql truncate table referencing itself

-- Original:
UPDATE 'recursive' SET 'parent_id' = NULL WHERE 'parent_id' IS NOT NULL;
DELETE FROM 'recursive';

-- For Example:
UPDATE Items
	SET Items.ParentItemId = NULL 
    WHERE Items.ParentItemId IS NOT NULL;
DELETE FROM Items;
-- Or 
TRUNCATE TABLE Items;

Source: stackoverflow.com

Similar codes

1 vote354 views1 answer
Oracle select first result
SQL
0 vote346 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote353 views3 answers
Magento 2 order delete from db
SQL
0 vote333 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote354 views1 answer
Creating a simple notify in postgresql
SQL
1 vote342 views1 answer
Oracle create index if not exists
SQL
11 votes374 views4 answers
Update row in mysql
SQL
2 votes342 views1 answer
Oracle drop table free up space
SQL
0 vote350 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote381 views1 answer
Gcloud sql list databases
SQL