CREATETABLE–SQLCommand
sql>CREATE TABLE – SQL Command
Creates a table having the specified fields.
CREATE TABLE | DBF TableName1 [NAME LongTableName] [FREE] (FieldName1 FieldType [(nFieldWidth [, nPrecision])] [NULL | NOT NULL] [CHECK lExpression1 [ERROR cMessageText1]] [DEFAULT eExpression1] [PRIMARY KEY | UNIQUE] [REFERENCES TableName2 [TAG TagName1]] [NOCPTRANS] [, FieldName2 ...] [, PRIMARY KEY eExpression2 TAG TagName2 |, UNIQUE eExpression3 TAG TagName3] [, FOREIGN KEY eExpression4 TAG TagName4 [NODUP] REFERENCES TableName3 [TAG TagName5]] [, CHECK lExpression2 [ERROR cMessageText2]])| FROM ARRAY ArrayName
Parameters
- TableName1
- Specifies the name of the table to create. The TABLE and DBF options are identical.
- NAME LongTableName
- Specifies a long name for the table. A long table name can be specified only when a database is open because long table names are stored in databases.
Long names can contain up to 128 characters and can be used in place of short file names in the database.
- FREE
- Specifies that the table will not be added to an open database. FREE isnt required if a database isnt open.
- (FieldName1 FieldType [(nFieldWidth [, nPrecision])]
- Specifies the field name, field type, field width, and field precision (number of decimal places), respectively.
A single table can contain up to 255 fields. If one or more fields allow null values, the limit is reduced by one to 254 fields.
FieldType is a single letter indicating the fields data type. Some field data types require that you specify nFieldWidth or nPrecision, or both.
The following table lists the values for FieldType and whether nFieldWidth and nPrecision are required.
FieldType nFieldWidth nPrecision Description C - 上篇文章：CORBA 入门
- 下篇文章：ervlet的重定向技术综述
