/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 vote243 views1 answer
Ms sql how to see active job current run time
SQL
0 vote290 views1 answer
Postgresql comandos basicos
SQL
7 votes271 views4 answers
How to reset the identity column in sql server
SQL
11 votes282 views2 answers
Oracle all source
SQL
9 votes295 views3 answers
Show table columns mysql command line
SQL
4 votes287 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote274 views1 answer
Resulting Query
SQL
0 vote299 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote310 views2 answers
Mysql extract number from string
SQL
0 vote285 views1 answer
Mysql search multiple tables
SQL