/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

7 votes223 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote244 views1 answer
Drop procedure sql
SQL
13 votes265 views3 answers
List all the tables in sql
SQL
9 votes225 views4 answers
Add primary key to existing table sql
SQL
0 vote231 views1 answer
Dapper run sql script with parameters
SQL
0 vote254 views1 answer
Query builder doctrien return sql
SQL
22 votes263 views3 answers
Year format in date mysql
SQL
1 vote262 views1 answer
Mysql take number in string
SQL
2 votes229 views1 answer
Sql server check for value in multiple columns
SQL
0 vote248 views1 answer
How to connect to xampp sql server on windows cmd
SQL