CRUD (Create, read, update and delete) in Databases

SQL Server

When talking about databases we often use the terms create, read, update and delete (CRUD), which are the four basic functions of persistent storage. Sometimes CRUD is also used to describe user interface conventions that include the ability to view, search, and insert information for later storage, but I’m just going to talk about databases.

Using the acronym CRUD, we understand that a database must support the ability to “Create” new records, “Read” existing records, “Update” record values, or “Delete” existing records as they are no longer needed. This is obviously supported with SQL Server and other modern relational databases.

CRUD is a term you should know and understand as it relates to database and application design.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s