Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to truncate table with foreign key constraint postgresql

TRUNCATE table_name RESTART IDENTITY CASCADE;
Comment

PREVIOUS NEXT
Code Example
Sql :: mariadb add foreign key 
Sql :: drop index in sql 
Sql :: change auto increment mysql 
Sql :: mysql case when on date 
Sql :: sparql list all graphs 
Sql :: DROP TABLes regardless of constraints 
Sql :: enable constraint in sql 
Sql :: add current timestamp in mysql 
Sql :: create table in sql 
Sql :: sql alter type of column 
Sql :: create_engine sqlalchemy with parsed url sql server 
Sql :: t sql null or empty string 
Sql :: select last row mysql 
Sql :: mysql regexp_replace remove html tag 
Sql :: get number of table colums in sql query 
Sql :: sql calculate working days between two dates excluding weekends and holidays 
Sql :: sql convert date to string yyyy-mm-dd 
Sql :: mysql list tables by size 
Sql :: oracle revoke 
Sql :: sql change a colum to unique 
Sql :: oracle list grants on procedure 
Sql :: codigo crear tablas sql server 
Sql :: mysql 1 hour ago 
Sql :: sql count null as 0 
Sql :: mysql delete duplicates 
Sql :: how to lock table in mysql 
Sql :: postgresql remove new line from string 
Sql :: sql between 
Sql :: ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides 
Sql :: sort by mysql 
ADD CONTENT
Topic
Content
Source link
Name
1+7 =