Export (0) Print
Expand All
Expand Minimize
1 out of 7 rated this helpful - Rate this topic

CREATE Command

Opens the Table Designer so you can create a Visual FoxPro table.


CREATE [FileName | ?]

Parameters

[ FileName| ?]

Specifies the name of the table to create or opens the Create dialog box so you can browse for a location to save the table and specify the name of the table to create.

If a database is open when you create a table, the table is added automatically to the database.

When running on the Windows operating system, you cannot create a table with the name of an MS-DOS device, such as CON, NUL, PRN, and COM1. Avoid using hyphens in a table name because hyphenated table names do not appear in the Data Session window and can cause confusion with the alias pointer (->).

After opening the Table Designer, you need to define attributes for the fields in the table. After you create the table structure, you can add records to the table. For more information, see Creating Tables.

The SQL CREATE TABLE command makes it possible to specify fields and their attributes programmatically. For more information, see CREATE TABLE - SQL Command.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.