/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 vote162 views1 answer
Sql select first and last record of each group
SQL
0 vote103 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
1 vote191 views1 answer
Insert pg result of select
SQL
0 vote163 views1 answer
Count database access django
SQL
1 vote134 views1 answer
Join first name and last name sql
SQL
-2 votes152 views1 answer
Modify column name in tsql
SQL
-1 vote144 views1 answer
Mysql order by on condition
SQL
0 vote142 views1 answer
Double in sql server example
SQL
0 vote146 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
1 vote161 views2 answers
Select only columns that are not empty oracle sql
SQL