SQL - CREATE TABLE

Data System Architecture

About

CREATE TABLE is a SQL statement that creates a table.

Example

CREATE TABLE Employees (
    EmployeeID INT,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Department VARCHAR(50),
    HireDate DATE
);





Discover More
Data System Architecture
SQL Data Type - NCHAR (NATIONAL CHARACTER)

NATIONAL CHAR is a SQL data type that: stores a char and uses as character set: the National Character set instead of the default character set of the operating system A create table statement...
Data System Architecture
SQL Data Type - NVARCHAR (NATIONAL CHARACTER VARYING)

NATIONAL VARCHAR is a SQL data type. It stores a varchar and uses as character set: the National Character set instead of the character set of the operating system A create table statement that...
Counting Table
What is a Table in SQL?

A table is: a SQL object with a relational data structure (ie a relation) that stores data queryrelation The name comes from the Abacuscounting table (abacus) that was found in the medieval...



Share this page:
Follow us:
Task Runner