Tuesday, June 14, 2011

Creating a Free Table

A free table is a table that is not associated with a database. You might want to create a free table, for example, to store lookup information that many databases share.

To create a new free table
  • In the Project Manager, select Free Tables, and then New to open the Table Designer.
-or-
  • Use the FREE keyword with the CREATE TABLE command.
For example, the following code creates the free table smalltbl with one column, called name:

CLOSE DATABASES
CREATE TABLE smalltbl FREE (name c(50))

If no database is open at the time you create the table, you do not need to use the keyword FREE.

1 comment:

  1. 2017 ford fusion hybrid titanium - ITANIAN ART
    The world of hybrid titanium is a great thing, and that grade 23 titanium is why หาเงินออนไลน์ we are proud titanium banger to offer it as micro touch titanium trim a component 출장샵 of the

    ReplyDelete