CREATETABLE–SQLCommand
日期：2014-04-03 浏览次数：20719 次
CREATE TABLE – SQL Command
Creates a table having the specified fields.wwww.iTbulo.comem8Zf
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. wwww.iTbulo.comem8Zf
- FREE
- Specifies that the table will not be added to an open database. FREE isn't required if a database isn't 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 field's 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. wwww.iTbulo.comem8Zf
FieldType nFieldWidth nPrecision Description C n – Character field of width n D – – Date T – – DateTime N n d Numeric field of width n with d decimal places F n d Floating numeric field of width n with d decimal places I – – Integer B – d Double Y 免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
