2. Introducing SQL
Introducing SQL
SQL Functionality
SQL statements enable you to:
Manipulate database objects—Create, modify, and destroy a variety of database objects, such as tables, views, indexes, and database procedures.
Manipulate data—Select, insert, update, and delete data in database tables.
Manage groups of statements as transactions—Process a group of database statements as a single transaction. Transaction management includes the ability to undo (roll back) a transaction, either in whole or in part.
Perform other database management functions—Set runtime options, copy data between tables and files, modify the characteristics of a database table, and perform many other database management functions.