Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

SQL: Create Tables

Posted on February 23, 2021 By rich No Comments on SQL: Create Tables

This SQL script will create three tables in the TechShizz database. There is a variation of data types for each column. SQL Server will run this script in three batches. To run all at once, remove the GO statement after CREATE TABLE statement.

USE TechShizz
GO

CREATE TABLE Employees
(
    EmployeeID int NOT NULL,
    FirstName nvarchar(50) NOT NULL,
    MiddleName nvarchar(50) NULL,
    LastName nvarchar(75) NOT NULL,
    Title nvarchar(100) NULL,
    HireDate datetime NOT NULL,
    VacationHours smallint NOT NULL,
    Salary decimal(19,4) NOT NULL,
)
GO

CREATE TABLE Products
(
    ProductID int NOT NULL,
    Name nvarchar(255) NOT NULL,
    Price decimal(19,4) NOT NULL,
)
GO

CREATE TABLE Sales
(
    SaleID uniqueidentifier NOT NULL,
    ProductID int NOT NULL,
    EmployeeID int NOT NULL,
    Quantity smallint NOT NULL,
)
GO

Post navigation

❮ Previous Post: SQL: Information on SQL Server Editions and Features
Next Post: SQL: Create a Database ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown