CREATE TABLE
CREATE TABLE — statement is used to create a new table in a database.CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, .... );The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).
CREATE TABLE - Popular snippets
- MySQL 8.0 CREATE TABLE
last run:
2025-02-11 08:13:38
263
- PostgreSQL 14 CREATE TABLE INSERT INTO SELECT ORDER BY
last run:
2025-02-03 13:21:32
210
- MySQL 8.0 CREATE TABLE INSERT INTO DELETE WHERE AND SELECT
last run:
2025-02-08 10:36:37
203
- MariaDB 11.5 CREATE TABLE NOT AUTO_INCREMENT DEFAULT UPDATE PRIMARY KEY INSERT INTO SELECT WHERE GROUP BY AND LEFT JOIN INNER JOIN ORDER BY
last run:
2024-12-03 12:28:55
184
- Oracle Database 21c CREATE TABLE INSERT INTO SELECT SUM LEFT JOIN GROUP BY
last run:
2025-02-13 14:44:43
175
- CREATE TABLE INSERT INTO
last run:
2024-12-04 19:13:59
172
- PostgreSQL 15 CREATE TABLE DEFAULT PRIMARY KEY INSERT INTO LEAD NOT SELECT
last run:
2025-02-04 00:27:16
158
- MS SQL Server 2017 CREATE TABLE SELECT SUM COUNT LEFT OUTER JOIN GROUP BY
last run:
2023-08-30 12:37:31
136
- MySQL 8.0 CREATE TABLE PRIMARY KEY AUTO_INCREMENT INSERT INTO SELECT WHERE IN GROUP BY HAVING ORDER BY
last run:
2025-02-14 15:22:19
134
- MySQL 8.0 CREATE TABLE INSERT INTO WITH SELECT WHERE CONCAT INNER JOIN CASE NOT ORDER BY BETWEEN AND LEFT JOIN
last run:
2025-01-13 10:42:44
127
CREATE TABLE - New snippets
-
PostgreSQL 16 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO SELECT CASE COUNT GROUP BY WHERE IN UPDATE BETWEEN AND
added at:
2025-02-14 20:38:18
2
-
PostgreSQL 16 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO SELECT CASE COUNT GROUP BY WHERE IN UPDATE BETWEEN AND
added at:
2025-02-14 20:36:16
1
-
PostgreSQL 16 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO SELECT CASE COUNT GROUP BY WHERE IN UPDATE BETWEEN AND
added at:
2025-02-14 20:34:32
1
-
PostgreSQL 16 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO SELECT CASE COUNT GROUP BY WHERE IN UPDATE BETWEEN AND
added at:
2025-02-14 20:33:08
1
-
PostgreSQL 16 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO SELECT CASE COUNT GROUP BY WHERE
added at:
2025-02-14 20:31:11
1
-
PostgreSQL 16 CREATE TABLE PRIMARY KEY
added at:
2025-02-14 20:29:05
1
-
Oracle Database 21c CREATE TABLE PRIMARY KEY ALTER TABLE ADD CONSTRAINT FOREIGN KEY DELETE CONSTRAINT INSERT INTO UPDATE WHERE DROP COLUMN
added at:
2025-02-14 17:53:54
2
-
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT UPDATE WHERE SHOW
added at:
2025-02-14 17:53:52
1
-
MySQL 8.0 CREATE TABLE LIKE INSERT INTO SELECT UPDATE WHERE SHOW
added at:
2025-02-14 17:53:39
1
-
Oracle Database 21c CREATE TABLE PRIMARY KEY ALTER TABLE ADD CONSTRAINT FOREIGN KEY CONSTRAINT INSERT INTO UPDATE WHERE DROP COLUMN DELETE
added at:
2025-02-14 17:53:05
1