Free Web Development Online Tutorials, Learn to Code
Learn how to create SQL table in SQL server database, MS SQL Table Tutorial for beginners

Create SQL Table Syntax in MS SQL

Create table in SQL server database and insert data, learn Create SQL Table syntax.

In this tutorial will learn Table in SQL Database, Here we learn database with a practical example.

So, just think of some business requirement, and you will learn how to develop SQL Table and manipulate data as per business requirement.

Recruitment:

We want to create a SQL Table where all students’ data will be stored, so whenever a student joins this training course their Name, email, date of birth, contact number, joining date, address, and course complete date will be captured

How to ceate table in SQL Database

Here we have written a create table sql query, notice the illustration , you can see how to write table name, column name, data type of column, null or not null, identity column and primary key etc.

how to ceate table in sql database

Create table query same as above

CREATE TABLE [dbo].[tbStudent](            
    [studentId] [bigint] IDENTITY(1,1) NOT NULL,
    [FullName] [varchar](50)  NOT NULL,
    [Address] [varchar](150)  NULL,
    [email] [varchar](100)  NULL,
    [contactnumber] [varchar](50)  NULL,
    [DOB] [datetime] NULL,
    [updatedon] [datetime] NULL,
    [courseCompleteDate] [datetime] NULL,
    [joiningDate] [datetime] NULL,
    CONSTRAINT [PK_tbStudent] PRIMARY KEY CLUSTERED            
    (
    [studentId] ASC
    )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Things to remember while creating a table
  • Table name must be unique; you can't have two tables with same name.
  • Column name in a table must be unique; two columns name cannot be same.
  • One table can have single or composite primary key
  • Primary key not necessarily will have IDENTITY (1, 1) seed, (but most of the time have)

How to insert data into SQL table

INSERT INTO [tableName] (columnName1, columnName2) values (value1, value2)
INSERT INTO [tbStudent]
([FullName]
,[Address]
,[email]
,[contactnumber]
,[DOB]
,[updatedon]
,[courseCompleteDate]
,[joiningDate])
VALUES
    ('Bill Zuckerberg'
    ,'Mumbai, India'
    ,'webtrainingroom@gmail.com'
    ,'9800000012'
    ,'09/10/1990'
    ,getdate()
    ,'10/10/2019'
    ,getdate())

SQL Temp Table

You should also learn SQL Temp Table and Table variable

 
Create SQL Table in SQL Database

SQL job Interview Questions Answers
Course in Demand
MS SQL Examples | Join MS SQL Course