SQL Administration

SQL provides the means of administering / managing the key database objects:

• SQL Database
• SQL Table and Column
• SQL Index
• SQL Foreign Key
• SQL View

The tutorial shows how to CREATE, ALTER and DROP as appropriate each of the major relational database objects.

SQL Objects and Operations

SQL Object	CREATE	ALTER	DROP
SQL DATABASE	SQL CREATE DATABASE	---	SQL DROP DATABASE
SQL TABLE	SQL CREATE TABLE	SQL ALTER TABLE	SQL DROP TABLE
SQL INDEX	SQL CREATE INDEX	---	SQL DROP INDEX
SQL FOREIGN KEY	SQL ADD FOREIGN KEY	---	SQL DROP FOREIGN KEY
SQL VIEW	SQL CREATE VIEW	---	SQL DROP VIEW