![]() |
Cloudscape System Tables
|
Reference Manual |
SYSKEYSDescribes the specific information for primary key and unique constraints within the current database. Cloudscape generates an index on the table to back up each such constraint. The index name is the same as SYSKEYS.CONGLOMERATEID.
IndexesSYSKEYS_INDEX1 unique BTREE index on (CONSTRAINTID) Example QueriesThe following query returns the name of the index backing up the primary key constraint called FlightAvailability_pk:
SELECT cn.CONGLOMERATENAME FROM SYS.SYSCONSTRAINTS c, |
|||||||||||||||
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |