From the course: Microsoft SQL Server 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a table using Management Studio

Create a table using Management Studio - SQL Server Tutorial

From the course: Microsoft SQL Server 2016 Essential Training

Start my 1-month free trial

Create a table using Management Studio

“

- [Instructor] In this section, we're going to create a table using SQL Server Management Studio. So I'll expand one of the demo databases and go to the tree item for Tables. I'm going to right-click and go to New Table and this provides the basic interface for me to add columns to the table. For the most part, I can name the columns whatever I like, and then I'll need to give it a Data Type. There's quite a number of Data Types available to us, you certainly don't have to use all of them. Some of them are designed for storing numbers, either with decimal places or without decimal places. Similar design for storing dates or times, or both date and time, and we also have some for storing different types of text. For text we often use a Variable Character Field, also known as a varchar. You will also see an option in this dropdown for Nvarchar. The N means Unicode characters. So if we want to go beyond the typical alphabet and do the full set of Unicode characters, you'll need to select…

Contents