From the course: Microsoft SQL Server 2022 Essential Training

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Edit a table's structure

Edit a table's structure - SQL Server Tutorial

From the course: Microsoft SQL Server 2022 Essential Training

Start my 1-month free trial Buy for my team

Edit a table's structure

“

- Occasionally you'll want to make a change to the structure of a table and management studio will step in and prevent you from saving the change. This is especially true when you're just starting out with SQL Server and you're building things on the fly and then go back and revise your database after the fact. For instance, let's go back into the customer's table that we just created and I'll right click on it and open it back up in the design tool. Now, if I've decided that 100 characters for the address data isn't going to be enough for the data that I want to store I might want to come in and make a change to that. I'll click on this column and then come down into the column properties and change its length. For instance, I'll change this up to store 150 characters instead. Seems like a simple change to make here but when I come back up into the toolbar and click the save icon or press Control S on my keyboard you'll…

Contents