/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

11 votes126 views1 answer
Get ddl materialized view oracle
SQL
0 vote166 views1 answer
For select oracle
SQL
3 votes128 views4 answers
Order by desc postgres
SQL
0 vote140 views1 answer
Trigger stock phpmyadmin output message
SQL
31 votes140 views3 answers
Sql count
SQL
0 vote172 views1 answer
AddEntityFrameworkSqlite
SQL
2 votes131 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote133 views1 answer
Sql server concat null
SQL
1 vote123 views1 answer
How to delete a record from sqlite in android
SQL
2 votes91 views1 answer
Oracle current date without time
SQL