/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 votes131 views1 answer
Oracle index size calculation
SQL
0 vote144 views1 answer
List all indexes postgres
SQL
0 vote146 views2 answers
Connect to mysql server mac terminal
SQL
2 votes161 views2 answers
Calculate percentage in sql
SQL
3 votes130 views2 answers
Oracle synonym
SQL
2 votes146 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote133 views1 answer
How to find username and password in oracle 18c
SQL
0 vote150 views2 answers
Return the number of records in a single table mysql
SQL
1 vote277 views1 answer
Sql check roles
SQL
11 votes153 views5 answers
Sql server reset identity
SQL