In this lesson you’ll learn the basics of table creation, alteration, and deletion.
SQL is not used just for table data manipulation. Rather, SQL can be used to perform all database and table operations, including the creation and manipulation of tables themselves.
There are generally two ways to create database tables:
• Most DBMSs come with an administration tool that can be used to create and manage database tables interactively.
• Tables may also be manipulated directly with SQL statements.
To create tables programmatically, the
CREATE TABLE SQL statement is used. It is worth noting that when you use interactive tools, you are actually using SQL statements. Instead of your writing ...