From the course: Microsoft SQL Server 2019 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 simple table

Create a simple table - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial

Create a simple table

“

- [Instructor] I'd like to create a table in the Landen Hotel database to store information about the guests of the hotel. In Management Studio we can create a table by drilling into the database by expanding on the plus button here and then right-clicking on the Tables folder and pointing to New. Sequel Server supports several different kinds of tables. The first option that just says Table is the standard type of data table used in most relational databases, but you can also create memory optimized tables which will store data in system memory as well as on disk, so they're faster to read and write to. Temporal tables, maintain date and timestamps for every change made to the data that they store. This allows you to essentially look back in time and see the state of the data as it was at any point. Regular data tables don't include this capability. It can only show you the current state of the data. Graph tables are structured differently than tables that follow the relational model…

Contents