Languages
[Edit]
EN

MS SQL Server - Create table

0 points
Created by:
Roseanne-Read
945

In this article, we would like to show you how to create a table in MS SQL Server.

Quick solution:

CREATE TABLE [table_name] (
    [column1] DATA_TYPE,
    [column2] DATA_TYPE,
    [column3] DATA_TYPE,
   ...
);

Note:

Go to the official documentation to see available DATA_TYPES.

Practical example

In this example, we create users table with the following columns and types:

  • id - INT,
  • name - VARCHAR,
  • role - VARCHAR. 

Query:

CREATE TABLE [users] (
    id INT IDENTITY(1,1),
    name VARCHAR(100) NOT NULL,
    role VARCHAR(15) NOT NULL,
    PRIMARY KEY (id)
);

Database:

Table columns created by SQL CREATE TABLE - HeidiSQL preview
Table columns created by SQL CREATE TABLE - HeidiSQL preview

References

Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Join to our subscribers to be up to date with content, news and offers.

Cross technology - Create table

Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join