/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 vote230 views1 answer
Postgresql check total storage
SQL
1 vote242 views1 answer
Postgresql export output table as a csv
SQL
0 vote219 views1 answer
Dapper run sql script with parameters
SQL
-2 votes221 views1 answer
Modify column name in tsql
SQL
1 vote229 views1 answer
Increase existing date in sql oracle
SQL
1 vote231 views1 answer
Woocommerce mysql price table
SQL
0 vote215 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote272 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote232 views1 answer
Pgsql sum switch case
SQL
0 vote231 views1 answer
Sql cnvert bit to nvarchar
SQL