/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

2 votes189 views1 answer
Sql server current date minus 5 years
SQL
3 votes169 views2 answers
Oracle grants
SQL
0 vote167 views1 answer
Sqlite update only if greater
SQL
0 vote196 views1 answer
Sql query use select name inside where clause
SQL
0 vote214 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote164 views1 answer
How to check if there is no database schema
SQL
4 votes170 views1 answer
Postgres delete last row
SQL
5 votes177 views1 answer
Mysql count lines
SQL
7 votes176 views4 answers
How to reset the identity column in sql server
SQL
0 vote233 views1 answer
Sql select rows between 1000 and 2000
SQL