common term for create,update,delete
What is the common term that we can use for Create/Update/Delete Operations? Can we use 'trans开发者_StackOverflow社区action'?
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
.
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
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.
It is commonly referred to as CRUD (Create, Read, Update and Delete).
精彩评论