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
:: mariadb add foreign key 
Sql ::  
Sql :: change auto increment mysql 
Sql :: mysql case when on date 
::  
Sql ::  
::  
:: mysql case when or 
::  
::  
::  
:: ms sql print from new line 
:: mysql export and import 
Sql :: sql server backup table 
Sql :: sql pagination 
:: vowels in sql 
:: replace null value within column mysql 
Sql ::  
::  
Sql :: excel export from sql using python 
:: check table exist postgresql 
::  
:: insensitive case match sqlalchemy 
:: mysql select default if null 
Sql ::  
:: mysql backup database 
Sql ::  
::  
Sql :: mysql run sql file 
Sql :: mariadb date equals to current_date plus days 
ADD CONTENT
Topic
Content
Source link
Name
2+4 =