CREATE TABLE

Introduction

The CREATE TABLE statement is used create a new table in the database. A table definition consists of a list of columns, their types, and any integrity constraints.

Syntax

CREATE TABLE tableName( [ColumnName1] [datatype1] [, [ColumnName2] [datatype2] …] )

Parameters

|Parameter | Details | |————|—–| |tableName|The name of the table| |columns | Contains an ‘enumeration’ of all the columns that the table have. See Create a New Table for more details.|

Remarks

Table names must be unique.

Found a mistake? Have a question or improvement idea? Let me know.

CREATE TABLE:

*CREATE TABLE

*Create a New Table

*Create Table From Select

*CREATE TABLE With FOREIGN KEY

*Duplicate a table

*Create a Temporary or In-Memory Table

Table Of Contents

0Getting started with SQL

3Example Databases and Tables

6CREATE TABLE

7UNION, UNION ALL

14Filter results using WHERE and HAVING

15Window Fnctions

16Common Table Expressions

18LIKE operator

19Functions Aggregate

21String Functions

23AND OR operators

28Finding Duplicates on a Column Subset with Detail

32Execution blocks

33Stored Procedures

37CREATE FUNCTION

38SQL Group by vs. Distinct

40CROSS APPLY and OUTER APPLY

42CREATE database

43SKIP TAKE pagination

44EXPLAIN and DESCRIBE

45Information Schema

48SQL Injection

49Cascading Delete

50Order of Execution

51DROP or DELETE database

55GRANT and REVOKE

56Functions ScalarSingle Row

57Relational Algebra

58EXISTS CLAUSE

59Materialized Views

60Functions Analytic

63Clean Code in SQL