FrontBase Documentation

Backtrack:
Welcome!
5. SQL 92
Updated: 20-Nov-2000
prev — next
Table of Contents

5.4. FrontBase Extensions

Although SQL 92 is a very comprehensive language, we have found the need for a few extensions.

Section/Article	Description
5.4.1. User Management	`CREATE USER...` `DROP USER...` `SET DEFAULT SCHEMA...` `ALTER USER...`
5.4.2. Index Management	`CREATE INDEX...` `DROP INDEX...` `CREATE UNIQUE INDEX...`
5.4.3. Table Cache Management	`ALTER TABLE <table-name> SET CACHE...`
5.4.4. Renaming Tables and Columns	`ALTER TABLE NAME...` `ALTER COLUMN NAME...`
5.4.5. Transaction Management	`SET TRANSACTION ISOLATION LEVEL VERSIONED;` `SET TRANSACTION LOCKING...`
5.4.6. Backup	`WRITE DATA [WITH TRANSACTION DATA];` `DROP TRANSACTION DATA;`
5.4.7. Unloading a Database	`WRITE ALL OUTPUT...`
5.4.8. Miscellaneous	`SELECT UNIQUE...` `SET UNIQUE...` `CURRENT_CATALOG` `CURRENT_SCHEMA`

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!