/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

0 vote177 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote177 views1 answer
18446744073709551615 mariadb left join order by
SQL
2 votes167 views1 answer
Mysql find tables with name
SQL
0 vote179 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
3 votes168 views2 answers
Sql random integer
SQL
10 votes174 views1 answer
Oracle dependencies table
SQL
1 vote168 views1 answer
Postgres regex remove special characters
SQL
5 votes167 views1 answer
How to check nls format in oracle
SQL
0 vote162 views1 answer
Find wordpress version in database
SQL
5 votes171 views1 answer
How to use rank function in sql
SQL