/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

5 votes137 views1 answer
Mysql change primary key
SQL
0 vote143 views1 answer
Sql server express download
SQL
-1 vote147 views1 answer
Auto increment psql not primary key
SQL
1 vote103 views1 answer
Database run
SQL
0 vote139 views1 answer
Pl sql constraint user function
SQL
1 vote138 views1 answer
Deleting database in sql
SQL
0 vote141 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote246 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote157 views1 answer
Oracle swap partition
SQL
0 vote139 views1 answer
Lost connection to mysql
SQL