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 Nvarchar instead of varchar.…