About 106,000,000 results
Open links in new tab
  1. 123

    Using SQL Server Management Studio (SSMS)

    1. Open SQL Server Management Studio (SSMS) and connect to your database instance.

    2. In Object Explorer, expand the Databases node and select the database where you want to create the table.

    3. Right-click on the Tables node and select New Table.

    4. In the Table Designer, enter the column names, select their data types, and specify whether NULL values are allowed for each column.

    5. To set a column as the Primary Key, right-click the column and select Set Primary Key.

    6. To configure additional properties (e.g., identity, constraints), use the Column Properties pane.

    7. From the File menu, select Save Table_1. Enter a name for the table and click OK.

    8. Refresh the Tables node in Object Explorer to view the newly created table.

    Using Transact-SQL (T-SQL)

    • Open SQL Server Management Studio (SSMS) and connect to your database instance.

    • Click New Query on the toolbar to open a query editor.

    • Use the following syntax to create a table:

    Feedback
  2. Microsoft Learn
    https://learn.microsoft.com › en-us › sql › relational...

    Create tables (Database Engine) - SQL Server | Microsoft Learn

    Nov 18, 2025 · You can create a new table, name it, and add it to an existing database, by using the table designer in SQL Server Management Studio (SSMS), or Transact-SQL. This task …

  3. W3School
    https://www.w3schools.com › sql › sql_create_table.asp

    SQL CREATE TABLE Statement - W3Schools

    The SQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in a database. Syntax CREATE TABLE table_name ( column1 datatype, column2 datatype, …

    Code sample

    CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),...
  4. GeeksForGeeks
    https://www.geeksforgeeks.org › sql-server › create-table-in-sql-server

    CREATE TABLE in SQL Server - GeeksforGeeks

    Jul 23, 2025 · In this article, we will learn how to efficiently use CREATE TABLE statements to create a table in our database. We will cover all the basic concepts with clear and concise …

  5. People also ask
    Feedback
  6. SQL Server Tutorial
    https://www.sqlservertutorial.net › sql-server...

    SQL Server CREATE TABLE: Creating a New Table in the Database

    Summary: in this tutorial, you will learn how to use the SQL Server CREATE TABLE statement to create a new table. Tables are used to store data in the database. Tables are uniquely named …

  7. TutorialsTeacher.com
    https://www.tutorialsteacher.com › sqlserver › create-table

    Create a New Table in SQL Server - TutorialsTeacher.com

    To design a new table, open SSMS and connect to your sql server instance. In Object Explorer, expand the HR database or the database where you want to create a new table. Now, right-click …

  8. SQL Shack
    https://www.sqlshack.com › create-table-stateme…

    CREATE TABLE statement in SQL Server

    Apr 29, 2022 · Learn how to create a table in SQL Server with various scenarios, such as schema, constraints, filegroup, and temporal table. See …

  9. SQL Server Tips
    https://www.mssqltips.com › sqlservertip › create...

    Create Table SQL Server Step by Step

    Jul 28, 2022 · In this SQL tutorial, we will start with the basics of creating a table (syntax, column definition, data types, constraints, etc.) and build …

  10. sqlservertutor.com
    https://www.sqlservertutor.com › create-table

    SQL Server Create table - SQL Server tutorial

    In this blog, we’ll dive into how to use the CREATE TABLE statement effectively, with examples and best practices. What is the CREATE TABLE Statement? The CREATE TABLE statement …

  11. datareportive.com
    https://datareportive.com › tutorial › sql-server › how-to-create-a-table

    How to Create a Table in SQL Server | DataReportive Tutorials

    Learn how to create a table in SQL Server, including syntax, best practices, and step-by-step instructions for table creation.

  12. TechOnTheNet
    https://www.techonthenet.com › sql_server › tables › create_table.php

    SQL Server: CREATE TABLE Statement - TechOnTheNet

    Let's look at an example of how to use the CREATE TABLE statement in SQL Server (Transact-SQL). For example: last_name VARCHAR(50) NOT NULL, first_name VARCHAR(50), salary …