Search⌘ K
AI Features
Home
Courses
Querying Databases Using Transact-SQL

Updating and Deleting Data from Tables

Explore how to update existing data and delete records from tables in Microsoft SQL Server using T-SQL commands. Understand the syntax and use of WHERE clauses to target specific rows, and learn how omitting conditions affects all data in the table.

We'll cover the following...

Data in an MS SQL Server database is not read-only by default. We can update and delete data when needed.

The UPDATE command

It is possible to make changes to existing data in tables. To modify the data, we use the UPDATE command, with this basic syntax:

UPDATE TableSchema.TableName
SET Column1Name = [NewValue], Column2Name =
...