Creating and Destroying Base Tables:
Example shows an SQL command to create the base table counterpart of the ENROLMENT variable
Example Creating a base table.
CREATE TABLE ENROLMENT
( StudentId SID ,
Name VARCHAR(30),
CourseId CID ,
PRIMARY KEY ( StudentId, CourseId )
) ;
(Example and the other examples in this chapter all end in semicolons. Actually, a semicolon is required in SQL only in scripts consisting of more than one statement. A script consisting of a single statement must not end in a semicolon.)