/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 vote188 views1 answer
Mysql check string don't have number
SQL
1 vote181 views1 answer
Sql server kill all connections
SQL
3 votes165 views1 answer
What is having clause
SQL
12 votes208 views1 answer
Run mysql instance in docker
SQL
1 vote179 views1 answer
Oracle finding duplicate records
SQL
0 vote188 views1 answer
How to to get time in sql
SQL
12 votes177 views1 answer
Create column sql server
SQL
-1 vote183 views1 answer
Capitole toulouse
SQL
0 vote184 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote231 views1 answer
Query only first letter string
SQL