Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

restart identity cascade

TRUNCATE <table_name> RESTART IDENTITY CASCADE;
--RESTART will reset the identity sequence
--CASCADE all tables that have a foreign key reference to 
--table_name will be truncated as well
 
PREVIOUS NEXT
Tagged: #restart #identity #cascade
ADD COMMENT
Topic
Name
2+2 =