Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql print all names that start with a given letter
Sql :: import local sql into remote mysql
Sql :: mysql add column default value
Sql :: create a table with an id in mysql
Sql :: ordering by issue with 4 digit numbers in sql
Sql :: altering the column name in MySQL to have a default value
Sql :: installing mysql on fedora
Sql :: sql current timestamp
Sql :: sometimes i cant edit sql developer
Sql :: mac os zsh: command not found: mysql
Sql :: postgres check timezone
Sql :: set password mysql
Sql :: create table sql server auto increment primary key
Sql :: sql delete stored procedure
Sql :: sql select column names
Sql :: mqtt Error: Address not available
Sql :: postgresql transaction discard all
Sql :: change month to name in sql server
Sql :: oracle user quota on tablespace
Sql :: mysql error codeigniter
Sql :: oracle cannot access v$session
Sql :: if then else sqlite
Sql :: Oracle NLS_CHARACTERSET
Sql :: sql myisam vs innodb
Sql :: alter table
Sql :: oracle ora-00054 resource busy
Sql :: oracle asynchronous query
Sql :: where to locate set password for mysql
Sql :: show size database mysql
Sql :: minus vs intersect in sql

Search

SQL

restart identity cascade

ADD CONTENT