sql truncate table referencing itself

Solutions on MaxInterview for sql truncate table referencing itself by the best coders in the world

Search
showing results for - "sql truncate table referencing itself"
Rosalie
17 Oct 2017
1-- Original:
2UPDATE 'recursive' SET 'parent_id' = NULL WHERE 'parent_id' IS NOT NULL;
3DELETE FROM 'recursive';
4
5-- For Example:
6UPDATE Items
7	SET Items.ParentItemId = NULL 
8    WHERE Items.ParentItemId IS NOT NULL;
9DELETE FROM Items;
10-- Or 
11TRUNCATE TABLE Items;
source
similar questions
how to truncate foreign key constraint tablehow to truncate all tables from sql servertrunc sqlwhat is truncate in sqldifference between drop and truncate in sqlwhat is truncateoracle sql truncate tablehow to truncate table with foreign key constrainthow to truncate a table in databsesql cmd no truncatesql truncate numbertruncate tablehow to truncate a table using sqltruncate sql servertruncate delete and drop in sqlcannot truncate a table referenced in a foreign key constrainttruncate table sqlitetruncate all tableshow to truncate all table in mysql workbenchsql truncms sql truncate table vs delete
queries leading to this page
sql truncate table referencing itselfsql truncate table referencing itself