/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 vote154 views2 answers
Sql searching via key word
SQL
0 vote139 views1 answer
Get number of rows in every table mysql
SQL
0 vote146 views1 answer
Longtext sql
SQL
0 vote180 views1 answer
Jooq replace
SQL
1 vote158 views1 answer
Quit mysql
SQL
0 vote155 views2 answers
How to find max and min salary in sql
SQL
0 vote147 views1 answer
Mysql url
SQL
1 vote158 views2 answers
Restart identity cascade
SQL
7 votes148 views4 answers
How to reset the identity column in sql server
SQL
1 vote145 views1 answer
Temp table vs variable table in sql server
SQL