This lesson covers the
DROP TABLE, and
DROP DATABASE statements, which are collectively known as data definition statements. In contrast, the
DELETE statements are often described as data manipulation statements. By the end of this lesson, you will understand and be able to do the following:
• Create key fields.
• Create a database with its associated tables.
• Create, alter, and drop a table.
• Drop databases.
You now know much of the SQL vocabulary and have examined the SQL query in some detail, beginning with its basic syntax. In Lesson 2, “Introducing the Query,” you learned how to select data from the database. Later in Lesson ...