Progress
SQL-89
Guide and Reference
Tables
A table is a collection of information organized into named columns. The following SQL statements are used to define, modify, and delete tables. You can use the following SQL statements to add and drop indexes.
CREATE TABLE
Creates a new, empty table and defines the columns and their data types.
ALTER TABLE
Adds new columns, deletes existing columns, or changes characteristics of existing columns.
DROP TABLE
Deletes a table from the database.
When you create a new database, the security administrator in the Data Administration tool is automatically set to an asterisk (*), which means that all users can create tables. To limit the users who can create tables, replace the asterisk with a list of user names.
When you create a table, you become the owner of that table. The owner is the first name in the privilege fields of the schema tables and, by default, is the only user who can access the table. You cannot change the owner.
The owner of a table can grant and revoke access privileges using the GRANT and REVOKE statements. In addition to controlling access privileges, the owner of a table is the only user who can alter or delete the table, and create or delete associated indexes.
NOTE: If you use SQL data definition statements to define or modify the schema for a database which does not have security defined for it, you may receive an error. If you access the database without security (that is, you do not connect with -U and -P), you must have a USER environment variable already defined. If the USER environment variable is blank, you will receive the error.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |