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
- CREATE TABLE NOT SELECT INSERT INTO WHERE BETWEEN AND
last run:
2023-06-28 09:35:52
4
- PostgreSQL 14 CREATE TABLE NOT SELECT INSERT INTO
last run:
2023-05-11 12:54:19
3
- MySQL 8.0 CREATE TABLE CREATE TABLE INSERT INTO
last run:
2023-08-30 12:41:25
3
- MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT
last run:
2025-04-20 17:27:25
2
- MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT
last run:
2025-04-20 16:48:56
2
- MS SQL Server 2019 CREATE TABLE NOT INSERT INTO SELECT CREATE VIEW WHERE
last run:
2025-04-02 01:43:51
2
- MS SQL Server 2019 CREATE TABLE NOT INSERT INTO SELECT CREATE VIEW WHERE
last run:
2025-04-02 01:36:38
2
- MS SQL Server 2022 CREATE TABLE NOT INSERT INTO SELECT WHERE UPDATE INNER JOIN DELETE DROP TABLE
last run:
2025-01-27 12:56:42
2
- PostgreSQL 14 CREATE TABLE NOT SELECT INSERT INTO WHERE BETWEEN AND
last run:
2023-05-11 12:51:17
2
- PostgreSQL 14 CREATE TABLE NOT SELECT INSERT INTO
last run:
2023-02-11 13:39:32
2
CREATE TABLE - New snippets
-
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT
added at:
2025-04-20 17:24:06
2
-
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT
added at:
2025-04-20 17:23:29
1
-
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT
added at:
2025-04-20 16:49:40
1
-
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT
added at:
2025-04-20 16:49:22
1
-
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT
added at:
2025-04-20 16:43:31
2
-
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO
added at:
2025-04-20 16:37:32
1
-
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT CREATE TABLE
added at:
2025-04-19 15:58:42
1
-
MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT CREATE TABLE
added at:
2025-04-19 15:58:25
1
-
MS SQL Server 2019 CREATE TABLE AND INSERT INTO SELECT
added at:
2025-04-16 01:36:52
1
-
MS SQL Server 2019 CREATE TABLE AND INSERT INTO SELECT
added at:
2025-04-16 01:36:07
1