FrontBase Documentation

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

5.4.8. Miscellaneous

SELECT UNIQUE FROM <table-name>;

Returns a value that can be used as a primary key (of type INT) for the given table.

SET UNIQUE FOR <table-name> (<primary-key-column>);

Sets the value that will be returned by the next SELECT UNIQUE...The value is calculated as SELECT MAX(<primary-key-column>) FROM <table-name>.

SET UNIQUE = <unsigned-number> FOR <table-name>;

Sets the value that will be returned by the next SELECT UNIQUE...

CURRENT_CATALOG

Returns the current catalog as a string (VARCHAR).

CURRENT_SCHEMA

Returns the current schema as a string (VARCHAR).

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!!