/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 vote276 views1 answer
Windows services sql
SQL
0 vote264 views1 answer
Sub blocks in sql
SQL
0 vote267 views1 answer
Postgres 11 add primary key
SQL
0 vote297 views1 answer
Running percentage of total postgres
SQL
9 votes293 views4 answers
How to alter table column name in mysql
SQL
4 votes288 views4 answers
Rollback in sql
SQL
3 votes261 views2 answers
Oracle for loop
SQL
1 vote316 views1 answer
Oracle select first row order by
SQL
13 votes278 views6 answers
Restart postgresql
SQL
1 vote261 views1 answer
Oracle list datafiles in tablespace
SQL