/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 vote200 views1 answer
Sql list all procedures
SQL
4 votes182 views1 answer
Oracle show errors
SQL
2 votes139 views1 answer
Sql select min value from multiple columns
SQL
4 votes238 views3 answers
Postgres drop all tables
SQL
0 vote187 views1 answer
Select even number id data from table
SQL
1 vote178 views1 answer
Oracle update with sequence
SQL
0 vote176 views1 answer
Sql period overlap
SQL
1 vote196 views1 answer
Sample in sql
SQL
4 votes184 views3 answers
Employee name starting with in sql
SQL
1 vote181 views1 answer
Mariadb case switch
SQL