common term for create,update,delete

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

Tags:

Sql