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
- MS SQL Server 2017 CREATE TABLE SELECT SUM COUNT LEFT OUTER JOIN GROUP BY
last run:
2023-02-06 08:55:18
132
- MySQL 5.7 CREATE TABLE INSERT INTO
last run:
2023-02-07 16:09:16
121
- MS SQL Server 2017 CREATE TABLE INSERT INTO
last run:
2022-12-29 06:38:02
92
- PostgreSQL 14 CREATE TABLE INSERT INTO SELECT ORDER BY
last run:
2023-01-29 11:09:13
92
- MS SQL Server 2017 CREATE TABLE INSERT INTO
last run:
2023-01-03 00:20:49
86
- MS SQL Server 2017 CREATE TABLE MONTH INSERT INTO WITH SELECT CROSS JOIN COALESCE SUM ORDER BY LEFT JOIN
last run:
2023-02-01 15:20:31
74
- MySQL 8.0 CREATE TABLE INSERT INTO DELETE WHERE AND SELECT
last run:
2023-01-31 17:45:10
69
- MySQL 8.0 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT INSERT INTO SELECT LEFT JOIN WHERE OR ORDER BY
last run:
2022-12-10 14:22:48
53
- MySQL 8.0 CREATE TABLE
last run:
2023-02-07 09:19:52
51
- MySQL 5.7 CREATE TABLE INSERT INTO SELECT COUNT() NULLIF() GROUP BY
last run:
2023-02-01 02:16:17
50
CREATE TABLE - New snippets
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO UPDATE SELECT
added at:
2023-02-08 14:34:25
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO UPDATE
added at:
2023-02-08 14:34:17
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO UPDATE
added at:
2023-02-08 14:34:10
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO UPDATE
added at:
2023-02-08 14:33:59
1
-
MySQL 5.7 CREATE TABLE INSERT INTO SELECT
added at:
2023-02-08 14:33:09
1
-
MySQL 5.7 CREATE TABLE INSERT INTO SELECT
added at:
2023-02-08 14:32:58
1
-
MySQL 5.7 CREATE TABLE INSERT INTO SELECT
added at:
2023-02-08 14:32:28
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO UPDATE CASE
added at:
2023-02-08 14:32:23
1
-
PostgreSQL 15 CREATE TABLE PRIMARY KEY DEFAULT INSERT INTO UPDATE CASE
added at:
2023-02-08 14:32:07
1
-
MySQL 5.7 CREATE TABLE INSERT INTO SELECT
added at:
2023-02-08 14:31:40
2