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 INSERT INTO
last run:
2021-11-18 21:27:21
68
- MySQL 5.7 CREATE TABLE INSERT INTO SELECT SUM WHERE GROUP BY
last run:
2021-11-11 05:54:22
33
- MySQL 5.7 CREATE TABLE SELECT INSERT INTO UPADTE
last run:
2021-10-16 11:10:53
31
- MySQL 8.0 CREATE TABLE SELECT INSERT INTO INNER JOIN
last run:
2021-11-28 21:04:58
28
- MySQL 5.7 CREATE TABLE INSERT INTO SELECT CASE SUM WHERE GROUP BY
last run:
2021-11-10 15:41:49
24
- PostgreSQL 13 CREATE TABLE SELECT INSERT INTO LEFT OUTER JOIN
last run:
2021-10-16 11:22:13
23
- PostgreSQL 13 CREATE TABLE INSERT INTO SELECT JOIN RANDOM()
last run:
2021-10-26 13:11:07
22
- MySQL 5.7 CREATE TABLE SELECT INSERT INTO UPDATE REPLACE()
last run:
2021-04-11 22:19:53
22
- MySQL 5.7 CREATE TABLE INSERT INTO SELECT COUNT() NULLIF() GROUP BY
last run:
2021-11-25 07:39:30
21
- MySQL 5.7 CREATE TABLE INSERT INTO
last run:
2021-10-28 17:24:29
18
CREATE TABLE - New snippets
-
MS SQL Server 2017 CREATE TABLE INSERT INTO SELECT RIGHT LEFT JOIN
added at:
2021-11-28 21:04:33
1
-
MS SQL Server 2017 CREATE TABLE INSERT INTO SELECT RIGHT LEFT JOIN GROUP BY
added at:
2021-11-28 21:03:48
1
-
PostgreSQL 14 CREATE TABLE PRIMARY KEY INSERT INTO UPDATE SELECT
added at:
2021-11-28 19:37:21
1
-
MySQL 5.7 CREATE TABLE PRIMARY KEY CONSTRAINT FOREIGN KEY INSERT INTO
added at:
2021-11-28 19:32:18
1
-
MySQL 5.7 CREATE TABLE PRIMARY KEY CONSTRAINT FOREIGN KEY INSERT INTO
added at:
2021-11-28 19:32:01
1
-
MySQL 5.7 CREATE TABLE PRIMARY KEY CONSTRAINT FOREIGN KEY INSERT INTO
added at:
2021-11-28 19:31:32
1
-
MySQL 5.7 CREATE TABLE CONSTRAINT FOREIGN KEY PRIMARY KEY INSERT INTO
added at:
2021-11-28 19:31:08
1
-
MySQL 5.7 CREATE TABLE CONSTRAINT FOREIGN KEY PRIMARY KEY INSERT INTO
added at:
2021-11-28 19:23:53
2
-
MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO
added at:
2021-11-28 19:23:36
1
-
MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO
added at:
2021-11-28 19:23:26
1