Determining the Database Layout
Creating a Data Model
Implementing a Data Model
Creating a Database
Size Requirement Considerations
Dropping and Adding Constraints
Defining a Unique Column
Defining a Primary and Foreign Key
Defining Check Constraints
Lock Mode Option
Temporary tables last for the time that your application program is processing or until your database is closed. A temporary table cannot have referential constraints placed on any defined columns nor can any column of the table be referenced from another table. If the user has connect privileges on the database, he can create a temporary table and build indexes on that temporary table.
When creating your tables, the only elements that are necessary are a unique table name within the database and unique column names within each table.