/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 votes196 views3 answers
Oracle tablespace usage
SQL
0 vote274 views1 answer
Get first monday of month sql
SQL
0 vote231 views1 answer
Sql value exists in column
SQL
0 vote160 views1 answer
Postgresql subquery
SQL
1 vote207 views1 answer
Oracle undo usage per session
SQL
0 vote325 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote255 views2 answers
Sqlalchemy default value for column
SQL
0 vote202 views2 answers
Sql server Insert Into table
SQL
0 vote227 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
53 votes605 views6 answers
How to install mysql ubuntu
SQL