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 2008 R2 Standard Server License key +5CAL FactorySealedPack

Price: $495
Buy It Now
Add-On Microsoft SQL Server 2008 R2 5CAL Standard Enterprise Datacenter Sealed!

Price: $199
Buy It Now
Brand New - Microsoft SQL Server 2014 Standard Edition SP2 and 25 CAL License

Price: $899
Buy It Now
Microsoft SQL Server 2012 Standard 10CAL +Server License Key Factory Sealed Pack

Price: $949
Buy It Now
Factory Sealed- 228-10602 Microsoft SQL Server 2016 Standard 10 CAL NEW!!

Price: $2169.99
Buy It Now
Factory Sealed - 228-09180 Microsoft SQL Server 2008 R2 Standard 10 CAL

Price: $1599
Buy It Now







Copyright 2017 - TSQLTutorials.com