Use the SQL Server Object Explorer to Add new tables to the database. You’ll see how to create a table and add fields, set the primary key and add check constraints to a table. There is a section that shows how to rename a table and how to remove an existing table.
- [Voiceover] There are several actions I can take…regarding tables in a database.…There are the obvious ones, I can add a new table,…I can rename an existing table,…and I can remove an existing table.…To add a new table, go to the Tables folder…in SQL Server Object Explorer and choose Add New Table.…You get a table with one field.…It's the identity field, I'll rename this…to something more meaningful.…Primary keys are usually an int,…so I'll leave that data type an int.…You don't allow nulls in primary keys,…so I'll leave this unchecked.…
I can see there is a primary key…in several areas on the screen.…There is a key symbol here on the left side of the screen…and over here in this area I see I have…one key inside my table, it's a primary key.…I can remove the key by right-clicking on the field…and choose Remove Primary Key.…The UI updates, the primary key symbol disappears,…and also over here you see I no longer have any keys.…To make a field a key, choose it from the list,…right-click, and set primary key.…Next I'll add a text field at NVARCHAR.…
- Exploring integration with Azure data sources and other Microsoft databases
- Working with SQL Server Express LocalDB
- Connecting to databases with Server Explorer
- Working with database tables
- Manipulating tables with the SQL Server Object Explorer
- Creating queries and custom views
- Creating stored procedures
- Comparing databases
- Building a data project in Visual Studio
- Refactoring a database object
- Deploying the database
- Connecting to Azure databases
- Deploying data projects to Azure
- Integrating Visual Studio with Entity Framework
Skill Level Beginner
Q: This course was updated on 08/23/2017. What changed?
A: The following topics were updated: installing the SSDT features and why LocalDB is essential for developers.
1. Database and Data Integration
The Azure data sources2m 35s
2. SQL Server Express LocalDB
3. Server Explorer
4. SQL Server Object Explorer
5. Queries, Views, and Stored Procedures
6. Compare databases
7. SQL Server Data Project
8. Azure Data
Get an Azure account1m 10s
9. Entity Framework
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.