Create Table SQL

Here is a practical example of how to create a table:

CREATE TABLE Employees (    EmployeeID INT NOT NULL,    FirstName VARCHAR(50),    LastName VARCHAR(50),    HireDate DATE,    PRIMARY KEY (EmployeeID));

This command creates an 'Employees' table with four columns:

• EmployeeID: An integer that uniquely identifies each employee.
• FirstName: The employee's first name, stored as a variable character string.
• LastName: The employee's last name, also a variable character string.
• HireDate: The date the employee was hired.

To create a simple table named 'Products' with an ID, Name, and Price, the SQL statement would read as follows:

CREATE TABLE Products (    ProductID INT NOT NULL,    ProductName VARCHAR(100),    Price DECIMAL(10, 2),    PRIMARY KEY (ProductID));

This command establishes a 'Products' table with the following columns:

• ProductID: An integer that serves as the primary key.
• ProductName: A string for the product's name.
• Price: A decimal that indicates the product's price.

Example 1: Creating a 'Customers' Table

CREATE TABLE Customers (    CustomerID INT NOT NULL,    CustomerName VARCHAR(100),    ContactEmail VARCHAR(100),    PRIMARY KEY (CustomerID));

This command creates a 'Customers' table with three columns:

• CustomerID: An integer identifier for each customer.
• CustomerName: A variable character string storing the customer's name.
• ContactEmail: A string representing the customer’s email address.

Example 2: Creating an 'Orders' Table

CREATE TABLE Orders (    OrderID INT NOT NULL,    OrderDate DATE,    CustomerID INT,    Amount DECIMAL(10, 2),    PRIMARY KEY (OrderID),    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID));

This command establishes an 'Orders' table with four columns and a foreign key:

• OrderID: An integer that uniquely identifies each order.
• OrderDate: The date when the order was placed.
• CustomerID: A reference to the customer who made the order.
• Amount: A decimal representing the total amount of the order.

Example 3: Creating a 'Products' Table

CREATE TABLE Products (    ProductID INT NOT NULL,    ProductName VARCHAR(100),    Price DECIMAL(10, 2),    Stock INT,    PRIMARY KEY (ProductID));

This example establishes a 'Products' table with four columns:

• ProductID: An integer that serves as the unique identifier for each product.
• ProductName: A string that names the product.
• Price: A decimal that indicates the price of the product.
• Stock: An integer denoting the number of units available.

For instance, to create a simple table named 'Students', the SQL statement can be structured as follows:

CREATE TABLE Students (    StudentID SERIAL PRIMARY KEY,    FirstName VARCHAR(50) NOT NULL,    LastName VARCHAR(50) NOT NULL,    EnrollmentDate DATE);

This command creates a 'Students' table with the following columns:

• StudentID: A unique identifier for each student, using the SERIAL data type for auto-incrementation.
• FirstName: A string for the student's first name, restricted to 50 characters.
• LastName: A string for the student's last name, also restricted to 50 characters.
• EnrollmentDate: The date on which the student was enrolled.