Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorials - Understanding SQL CREATE, ALTER and DROP Statements

By: FYIcenter.com

A collection of 17 FAQs on Oracle SQL DDL statements. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views; adding, renaming, and dropping table columns. Topics included in this FAQ are:

  1. What Are DDL Statements?
  2. How To Create a New Table?
  3. What Happens If You No CREATE Privilege in a Database?
  4. How To Get a List of All Tables in a Database?
  5. How To Get a List of Columns in an Existing Table?
  6. How To See the CREATE TABLE Statement of an Existing Table?
  7. How To Create a New Table by Selecting Rows from Another Table?
  8. How To Add a New Column to an Existing Table?
  9. How To Delete an Existing Column in a Table?
  10. How To Rename an Existing Column in a Table?
  11. How To Rename an Existing Table?
  12. How To Drop an Existing Table?
  13. How To Create an Index for a Given Table?
  14. How To Get a List of Indexes of a Given Table?
  15. How To Drop an Existing Index?
  16. How To Create a New View?
  17. How To Drop an Existing View?

Please note that all answers and tutorials are based on MySQL 5.0. Tutorial exercises should be executed with "mysql" or other MySQL client programs. It is also assumed that you have a MySQL user account and a predefined database with enough privileges.

Some sample scripts requires database tables created by other samples in the beginning of the collection.

(Continued on next topic...)

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...