How to Create a Table in SQL

13 Jul How to Create a Table in SQL

Posted at 14:24h in SQL by Studyopedia Editorial Staff 0 Comments

Learn how to create a new table after creating a database in Microsoft SQL Server. To create a table in SQL, use the CREATE TABLE statement.

First, we created a database amitdb in SQL using the CREATE DATABASE command:

create database amitdb;

Now, create a table employee using the CREATE TABLE command. We have four fields, employee id, name, city and salary:

create table employee (
  ID int,
  EmpName varchar(255),
  City varchar(255),
  Salary int
);

If you liked the tutorial, spread the word and share the link and our website Studyopedia with others:

Support us: DONATE

Read More:

Print page

We work to create programming tutorials for all.