TRUNCATE - Popular snippets
- MS SQL Server 2019 AND NOT BETWEEN IN OR WITH ORDER BY CREATE TABLE INSERT INTO SELECT COUNT ROW_NUMBER JOIN INNER JOIN WHERE RIGHT SUM LAG LIKE COALESCE CASE TRUNCATE GROUP BY
last run:
2023-08-07 20:42:18
43
- PostgreSQL 14 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRUNCATE
last run:
2023-09-20 14:08:45
28
- Oracle Database 21c CREATE TABLE INSERT INTO SELECT ALTER TABLE UPDATE WHERE TRUNCATE DROP TABLE DELETE CREATE VIEW NOT PRIMARY KEY FOREIGN KEY INNER JOIN LEFT JOIN RIGHT CROSS JOIN
last run:
2023-05-31 16:17:04
27
- Oracle Database 21c CREATE TABLE INSERT INTO SELECT ALTER TABLE UPDATE WHERE TRUNCATE DROP TABLE DELETE CREATE VIEW NOT
last run:
2023-03-28 16:30:48
14
- PostgreSQL 15 AND NOT BETWEEN IN OR WITH ORDER BY CREATE TABLE INSERT INTO SELECT COUNT ROW_NUMBER JOIN INNER JOIN WHERE RIGHT SUM LAG LIKE COALESCE CASE TRUNCATE GROUP BY
last run:
2023-04-22 18:55:04
10
- MS SQL Server 2019 CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT TRUNCATE
last run:
2022-08-10 08:16:12
9
- MS SQL Server 2019 TRUNCATE
last run:
2022-07-14 04:17:54
7
- PostgreSQL 14 CREATE TABLE PRIMARY KEY COUNT INSERT INTO ALTER TABLE ADD CONSTRAINT FOREIGN KEY CREATE FUNCTION SELECT WHERE AND UPDATE EXEC TRUNCATE DROP TABLE
last run:
2022-05-09 21:22:40
7
- MS SQL Server 2017 AND NOT BETWEEN IN OR WITH ORDER BY CREATE TABLE INSERT INTO SELECT COUNT ROW_NUMBER JOIN INNER JOIN WHERE RIGHT SUM LAG LIKE COALESCE CASE TRUNCATE GROUP BY
last run:
2023-05-19 23:40:55
6
- Oracle Database 21c CREATE TABLE INSERT INTO SELECT ALTER TABLE UPDATE WHERE TRUNCATE DROP TABLE DELETE CREATE VIEW
last run:
2023-03-29 02:52:01
6
TRUNCATE - New snippets
-
MS SQL Server 2017 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:49:19
1
-
MS SQL Server 2019 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:49:12
1
-
MS SQL Server 2022 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:48:59
1
-
SOQOL (beta) CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:48:46
3
-
MariaDB 10 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:48:04
1
-
MySQL 5.7 (Sakila - ReadOnly) CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:48:02
1
-
MySQL 5.7 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:47:59
1
-
SQLite 3 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:47:51
1
-
PostgreSQL 15 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:47:49
1
-
PostgreSQL 14 CREATE TABLE INSERT INTO TRUNCATE SELECT
added at:
2023-09-24 17:47:47
1