Dates and Times

Implementations of SQL normally support dates and times as special data types. These values are often representable in a variety of formats such as 5/14/1948 or 14 May 1948. Here we shall explain only the SQL standard notation, which is very specific about format.

Defining a Relation Schema in SQL

Now we shall begin a discussion of data definition, the portions of SQL that involve explaining the structure of information in the database. On the contrary, the aspects of SQL discussed previously - queries and modifications - are often called data manipulation.

Simple Table Declarations

The simplest form of declaration of a relation schema comprises the keywords CREATE TABLE followed by the name of the relation and a parenthesized list of the attribute names and their types.

Page 0 of 1 Previous 1 Next