/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

2 votes303 views2 answers
Postgres trigger insert into another table
SQL
0 vote275 views1 answer
Postgres select except
SQL
1 vote267 views1 answer
Mysql find tables with column name
SQL
15 votes287 views4 answers
Sql update from select
SQL
0 vote294 views1 answer
Convert rows to columns in sql server
SQL
0 vote274 views1 answer
Remove default constraint sql server
SQL
0 vote328 views1 answer
Mysql get first 2 characters of string
SQL
3 votes282 views3 answers
Your password does not satisfy the current policy requirements
SQL
13 votes479 views4 answers
Sql joining 3 tables
SQL
4 votes287 views1 answer
Oracle session date format
SQL