How do you create a table in Microsoft SQL Server database?
Experience Level: Junior
Tags: DatabasesQuality Assurance (QA)
Answer
There are two basic options:
Using SSMS designer
- Connect to the SQL Server instance
- Go to the Database and expand its node in Object Explorer
- Right click the node Tables and select New-Table
- Define the columns and their data types
- Click Save
Writing and executing SQL script using SSMS query window
- Connect to the SQL Server instance
- Go to the Database and expand its node in Object Explorer
- Click the New Query to open the query window
- Enter the SQL script for creating the table and execute it
Related Databases job interview questions
You have a table Users in your Microsoft SQL Server database. How do you generate script that would create the table? To goal is to use the this script to create the empty table Users with the same structure in a different database?
DatabasesQuality Assurance (QA) MediorHow do you retrieve and show all rows from the table in Microsoft SQL Server database using Microsoft SQL Server Management Studio (SSMS)?
DatabasesQuality Assurance (QA) JuniorUsing SSMS, where do you find the list of all tables within a database?
DatabasesMS SQL ServerQuality Assurance (QA) JuniorWhere do you find a list of databases on the SQL Server?
DatabasesQuality Assurance (QA) JuniorWhat is a data type?
DatabasesQuality Assurance (QA) Junior