/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

1 vote157 views2 answers
Copy database mysql
SQL
13 votes107 views2 answers
Oracle all source
SQL
0 vote247 views1 answer
Mssql unique key accept nulls
SQL
2 votes141 views1 answer
Oracle number to percentage
SQL
3 votes147 views2 answers
Postgresql remove not null constraint
SQL
0 vote157 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
1 vote154 views3 answers
Sql union
SQL
3 votes119 views2 answers
Coalesce mysql
SQL
0 vote165 views1 answer
Define a variable in mysql from select
SQL
0 vote158 views1 answer
Column ' ' in field list is ambiguous
SQL