T-SQL Tutorial

Create table T-SQL


DDL statement - create table

To create a new table you need to use create table command and define the columns of the table. A column need name, data type and size.

Create table

USE tempdb;
GO
CREATE TABLE Students
(ID int,
Name varchar(255),
Birthday date,
City varchar(500));
GO

Insert into table

USE tempdb;
GO
insert into Students(id,Name,Birthday,City)
values
(1,'Emma','1994-01-01','New York'),
(2,'Daniel','1995-06-08','Chicago'),
(3,'Joseph','1996-10-11','Dallas'),
(4,'Jennifer','1997-03-15','Los Angeles'),
(5,'Debra','1998-09-05','Dallas') ;
GO