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.