Menu
What is the common term that we can use for Create/Update/Delete Operations? Can we use 'transaction'?
425
CRUD is usually the technical term that is used to describe create/read/update/delete functionality. ... create, read, update and delete (CRUD) (Sometimes called SCRUD with an "S" for Search) are the four basic functions of persistent storage.
What is CRUD? CRUD is an acronym that comes from the world of computer programming and refers to the four functions that are considered necessary to implement a persistent storage application: create, read, update and delete.
CRUD (Create, Read, Update, Delete) is an acronym for ways one can operate on stored data. It is a mnemonic for the four basic functions of persistent storage.
After creating and populating a table in SQL, the UPDATE command can be used to change the value of a column. If there is no WHERE , it will change the value of all the rows in the table, so make sure you restrict what it updates with a correct WHERE condition. The DELETE command can be used to delete rows.
All these are called DML (Data Manipulation Language) statements.
They may be called transactions in the business world (e.g a transaction is something that modifies my account) but in the database world selects can also be transactional.
Also note that instead of create you most probably mean insert.
89
CUD (Create, Update, Delete) operations is used quite often to describe these actions. CUD is a play on CRUD (create, read, update, delete). You can see Microsoft even references this in their materials:
http://msdn.microsoft.com/en-us/library/bb546187.aspx
32
The word 'Process' can be used. Alternatively the words 'Alter' and 'Change' might be useful too. However, they don't sound like they include Create.
4
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
