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
SQL Server 2014 Standard Edition, Media & License | Full Retail | 10CAL Edition

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

Price: $995
Buy It Now
Microsoft SQL Server 2008 R2 Workgroup + 5 CAL

Price: $249.99
Buy It Now
Microsoft SQL 2008 R2 Server Standard 25 CAL 32/64-Bit NEW SEALED

Price: $350
Buy It Now
Microsoft SQL Server 2008 R2 Standard 10CAL Server License key FactorySealedPack

Price: $699
Buy It Now







Copyright 2017 - TSQLTutorials.com