Table-Level Tasks

Home | Previous Page | Next Page Using the Full-Screen Menu Interface > Alternative Approaches >

Table-Level Tasks

To create a table, allocate storage, or apply fragmentation, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
TABLE	Create	Uses the Schema Editor.	5
SQL	CREATE TABLE	Uses the SQL editor or system editor and SQL statements.	3

To make changes to the structure of a table, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
TABLE	Alter	Guides you, with menus, through the available choices for changing an existing table.	5
CREATE TABLE	Modify	Enables you to change a schema before you build the table.	5
SQL	ALTER TABLE	Changes an existing table according to the keywords you include with the statement.	3
SQL	ALTER FRAGMENT	Changes an existing fragmentation strategy (for a table or index). Creates the table fragments.	3

To drop a table from a database, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
TABLE	Drop	Drops the current table.	5
SQL	DROP TABLE	Drops the table named in the command.	3

To move a table from current database to another database, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
TABLE	Move	Guides you, with menus, through available choices for moving a table from the current database to another database.	5
SQL	Move Table	Moves the table named in the command.	3

To display information about the structure and characteristics of a table, use one of the following methods.

Menu Screen	Option or SQL Statement	Action	Chapter
TABLE	Info	Provides a menu of available table information categories.	5
SQL	Info (option)	Prompts you to select from a list of available tables and then provides the same menu as the Info option on the TABLE screen.	3
SQL	INFO (SQL statement)	Provides the information specified in the keywords you include with the INFO statement.	3

To display the data stored in a table, run a SELECT statement from the SQL editor. Use the procedures described in The Query-language Option.

Tip:

Several command files are included with DB–Access that contain sample practice SELECT statements. Appendix B. Demonstration SQL lists the demonstration files that are supplied with the stores_demo database.