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.