T-SQL Tutorials - TSQLTutorials.com

CREATE TABLE


Introduction

The CREATE TABLE statement is how new tables are created in SQL. Tables are the structures that hold data, in a relational database. The syntax for using the CREATE TABLE command is as follows:

  • CREATE TABLE [table name]
    (
      column name 1 datatype for column,
      column name 2 datatype for column
    )

Beginning Example

In this example we will create a simple 'Employees' table with a 'Name' column, 'Position' column and a 'Salary' column: CREATE TABLE Employees
(
  Name varchar(20),
  Position varchar(25),
  Salary int
)




Second Example

In this next example we will create the same 'Employees' table, but this time we will create an auto-incrementing primary key. CREATE TABLE Employees
(
  EmployeeKey int IDENTITY(1,1) PRIMARY KEY,
  Name varchar(20),
  Position varchar(25),
  Salary int
)


Microsoft SQL Server 2014 Standard Edition Server w/20 CAL’s

Price: $641.99
Buy It Now
MSFT SQL Server 2012 Standard Edition, 32bit & 64bit, Media & License w/25CAL

Price: $499.99
Buy It Now
MSFT SQL Server 2016 Standard Edition x64 64bit | 10 CAL USERS Edition

Price: $699.99
Buy It Now
Microsoft SQL Server 2014 Standard LicensePack +Microsoft USB +BONUS 10 or 25CAL
Price: $1179
Buy It Now
Brand New - Microsoft SQL Server 2012 Standard Edition SP3 and 10 CAL License

Price: $660
Buy It Now
Microsoft SQL Server 2012 Standard +Original Microsoft USB |10 or 25CAL| LIMITED
Price: $949
Buy It Now







Copyright 2017 - TSQLTutorials.com