Database Reference
In-Depth Information
10.1.1 Commonly Used DDL Statements
Figure 10-1 provides a list of commonly used DDL statements of SQL. You will observe
that the statements are self-explanatory. This makes learning of the language very easy,
particularly when compared to more cryptic traditional programming languages.
Another feature that you will notice about SQL is that it is symmetrical and follows
very consistent standards (language experts favor the term orthogonal to describe this
feature). Thus, for most database objects, you can create the object, alter (i.e. modify)
it, or drop (i.e. remove) it from the system. And the main database objects that you will
be working with are tables, indexes, constraints and views; in the case of Oracle, there
are also databases, tablespaces, sequences and synonyms. Of course, there are other
database objects that will be covered later in the course.
Figure 10-1. Commonly Used DDL Statements of SQL
 
Search WWH ::




Custom Search