SQLize - format run and share SQL queries online

Tags: MySQL 5.7 MySQL 8.0 MariaDB 10 SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 Oracle Database 11c Oracle Database 19c Oracle Database 19c Oracle Database 21c

DROP TRIGGER - Popular snippets

PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC last run: 2022-05-22 19:58:22
2
PostgreSQL 14 CREATE OR REPLACE FUNCTION INSERT INTO UPDATE DROP TRIGGER EXEC last run: 2022-04-22 10:05:24
2
PostgreSQL 12 DROP TRIGGER UPDATE WHERE last run: 2022-05-31 13:18:17
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC last run: 2022-05-22 19:59:48
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC last run: 2022-05-22 19:59:31
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC last run: 2022-05-22 19:58:15
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO CREATE OR REPLACE FUNCTION SELECT COUNT WHERE DROP TRIGGER EXEC last run: 2022-05-22 19:56:24
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE LIKE ALTER TABLE ADD COLUMN DEFAULT CREATE OR REPLACE FUNCTION EXEC DROP TRIGGER WHERE SELECT last run: 2022-05-22 19:55:46
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO CREATE PROCEDURE SELECT WHERE ORDER BY DELETE LIKE ALTER TABLE ADD COLUMN DEFAULT CREATE OR REPLACE FUNCTION EXEC DROP TRIGGER last run: 2022-05-22 19:54:34
1
PostgreSQL 14 CREATE OR REPLACE FUNCTION INSERT INTO UPDATE DROP TRIGGER EXEC last run: 2022-04-22 10:05:59
1

DROP TRIGGER - New snippets

PostgreSQL 12 DROP TRIGGER UPDATE WHERE added at: 2022-05-31 13:18:17
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC added at: 2022-05-22 19:59:48
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC added at: 2022-05-22 19:59:31
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC added at: 2022-05-22 19:58:15
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE WHERE CREATE OR REPLACE FUNCTION SELECT COUNT DROP TRIGGER EXEC added at: 2022-05-22 19:57:14
2
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO CREATE OR REPLACE FUNCTION SELECT COUNT WHERE DROP TRIGGER EXEC added at: 2022-05-22 19:56:24
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO DELETE LIKE ALTER TABLE ADD COLUMN DEFAULT CREATE OR REPLACE FUNCTION EXEC DROP TRIGGER WHERE SELECT added at: 2022-05-22 19:55:46
1
PostgreSQL 14 CREATE TABLE NOT CONSTRAINT PRIMARY KEY AND FOREIGN KEY INSERT INTO CREATE PROCEDURE SELECT WHERE ORDER BY DELETE LIKE ALTER TABLE ADD COLUMN DEFAULT CREATE OR REPLACE FUNCTION EXEC DROP TRIGGER added at: 2022-05-22 19:54:34
1
PostgreSQL 14 CREATE OR REPLACE FUNCTION INSERT INTO UPDATE DROP TRIGGER EXEC added at: 2022-04-22 10:05:59
1
PostgreSQL 14 CREATE OR REPLACE FUNCTION INSERT INTO UPDATE DROP TRIGGER EXEC added at: 2022-04-22 09:15:41
2

SQLize.online - Popular functions

CREATE TABLE

88k

SELECT

83k

INSERT INTO

79k

WHERE

46k

PRIMARY KEY

45k

NOT

33k

GROUP BY

22k

AND

22k

COUNT

21k

ORDER BY

21k

JOIN

19k

FOREIGN KEY

17k

UPDATE

14k

WITH

13k

AUTO_INCREMENT

12k

DELETE

10k

INNER JOIN

10k

LEFT

10k

IN

10k

DEFAULT

9k

SUM

9k

CONSTRAINT

9k

ALTER TABLE

7k

LIKE

6k

OR

5k

BETWEEN

5k

HAVING

5k

DROP TABLE

4k

CASE

3k

CREATE VIEW

3k

ROW_NUMBER

3k

SHOW

3k

CONCAT

2k

MONTH

2k

LAG

2k

EXEC

2k

RIGHT

2k

TRUNCATE

2k

OUTER JOIN

1k

COALESCE

1k

ADD COLUMN

1k

CREATE FUNCTION

1k

DENSE_RANK

1k

CROSS JOIN

845

LENGTH

837

SUBSTRING

835

LEAD

814

CREATE PROCEDURE

784

ADD CONSTRAINT

740

TRIM

709

CREATE OR REPLACE FUNCTION

589

LOWER

562

DROP COLUMN

560

DROP VIEW

540

REPLACE

533

DROP PROCEDURE

443

UPPER

437

DESCRIBE

394

INSERT INTO

302

REVERSE

257

LEFT JOIN

226

SUBSTR

209

JSON_ARRAY

155

INSERT INTO

154

136

JSON_CONTAINS

135

IFNULL

131

LTRIM

99

JSON_AGG

90

DROP CONSTRAINT

77

CREATE OR REPLACE PROCEDURE

73

GROUP BY

57

NULLIF

53

RTRIM

53

ORDER BY

51

ADD COLUMN

50

46

CREATE OR REPLACE FUNCTION

46

LPAD

42

CREATE OR REPLACE VIEW

40

DROP TABLE

38

INSERT INTO

30

DROP INDEX

28

INSERT INTO

24

CROSS JOIN

23

INSERT INTO

18

DROP FUNCTION

18

CREATE OR REPLACE FUNCTION

17

GROUP BY

17

UUID_GENERATE_V4

17

DROP SEQUENCE

15

13

ROW_TO_JSON

12

ORDER BY

12

DROP TRIGGER

12

INNER JOIN

10

INNER JOIN

9

FOREIGN KEY

8

7

RPAD

6

© 2022 SQLize - format run and share SQL queries online | About project | Disclaimer
PHP versions: 5.6.40, 7.4.14, 8.0.1, 8.1.5
RDBMS versions: MySQL 5.7.39, 8.0.30, MariaDB 10.8.3, PostgreSQL 11.16, 12.11, 13.7, 14.4, 15.beta Microsoft SQL Server 2017, 2019, SQLite 3, Oracle 21c, 19c (with predefined tables)