One of the simplest changes you can make to a SQL table is to add a field to the table definition. Learn how to use the SQL Server Object Explorer table designer to add a field to a table. Then see how to update the underlying database with the changes.
- [Voiceover] We've decided to add a new field…to an existing table in our database.…The table I need to modify is the tours table.…So I'll double click on it.…I think the easiest way to add a new field…is to go to the last row in the grid…and type the value in here.…We've decided that we wanna include this new information…on our website on whether or not we have meals…included as part of the tour price.…So the name of the field is meals included.…Now if I move off that row, you'll see that Visual Studio…stubs in some default values.…It sets the value of the data type to N chart 10…and it sets the allow nulls to true.…
I don't want this as my data type.…So I can do two things, I can either come here…and type a new value in here like that,…or I can click on the drop down…and look through this list.…This is a boolean value and in Sequel Server…you use a bit field for this.…It's also important that I have this allow nulls selected…because I currently have data in it…and if I uncheck this I'll get an error…when I try to update the database.…
Author
Walt Ritscher
Updated
8/30/2017Released
8/26/2016- 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
Duration
Views
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.
-
Introduction
-
Welcome1m 2s
-
Welcome1m
-
Install the SSDT features2m 13s
-
-
1. Database and Data Integration
-
The Azure data sources2m 35s
-
2. SQL Server Express LocalDB
-
3. Server Explorer
-
Manage connections2m 3s
-
Add a project level database1m 33s
-
Work with database tables3m 26s
-
4. SQL Server Object Explorer
-
Tour the Table Designer2m 24s
-
Add field to table2m 44s
-
Understand the Power Buffer3m 57s
-
Add or modify table data2m 30s
-
Add and remove tables4m 44s
-
5. Queries, Views, and Stored Procedures
-
Use the Query window5m 53s
-
Work with existing Views3m 33s
-
Create a custom View1m 40s
-
6. Compare databases
-
Data comparison5m 1s
-
Schema comparison5m 21s
-
7. SQL Server Data Project
-
Create a data project2m 4s
-
Add items to project3m 14s
-
Import an existing database2m 38s
-
Build the project2m 54s
-
The sandboxed debug database3m 48s
-
Refactor a database object3m 13s
-
Work with source control2m 24s
-
8. Azure Data
-
Get an Azure account1m 10s
-
-
9. Entity Framework
-
What is Entity Framework?3m 20s
-
Explore the EDM5m 7s
-
Use the Table Mapping window4m 27s
-
Use the Model Browser window2m 16s
-
Modify the EDM3m 13s
-
Use LINQ to query the EDM5m 10s
-
-
Conclusion
-
Next steps53s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Add field to table