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:
2024-11-21 21:43:46
80
- PostgreSQL 14 CREATE TABLE PRIMARY KEY INSERT INTO SELECT TRUNCATE
last run:
2024-11-20 07:31:30
45
- 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:
2024-10-01 20:19:34
12
- MS SQL Server 2022 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:
2024-11-05 19:22:16
9
- MS SQL Server 2019 CREATE TABLE NOT PRIMARY KEY INSERT INTO SELECT TRUNCATE
last run:
2022-08-10 08:16:12
9
- MySQL 5.7 CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY ALTER TABLE FOREIGN KEY UPDATE DELETE INSERT INTO WHERE TRUNCATE AND SELECT
last run:
2023-10-11 08:06:49
8
- MySQL 5.7 TRUNCATE
last run:
2024-05-29 12:35:01
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:
2024-11-05 19:22:33
7
TRUNCATE - New snippets
-
MySQL 8.0 Sakila (ReadOnly) SELECT TRUNCATE
added at:
2024-12-30 10:09:55
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT TRUNCATE GROUP BY ORDER BY
added at:
2024-12-30 10:09:48
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT GROUP BY ORDER BY TRUNCATE
added at:
2024-12-30 10:09:32
1
-
PostgreSQL 10 Bookings (ReadOnly) SELECT TRUNCATE
added at:
2024-12-29 15:35:22
1
-
PostgreSQL 10 Bookings (ReadOnly) SELECT TRUNCATE
added at:
2024-12-29 15:32:43
1
-
MySQL 8.0 Sakila (ReadOnly) TRUNCATE
added at:
2024-12-25 13:59:41
1
-
PostgreSQL 10 Bookings (ReadOnly) SELECT TRUNCATE
added at:
2024-12-18 02:00:17
1
-
PostgreSQL 10 Bookings (ReadOnly) SELECT TRUNCATE
added at:
2024-12-18 02:00:09
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT TRUNCATE
added at:
2024-12-16 00:26:09
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT TRUNCATE
added at:
2024-12-16 00:25:51
1