You can navigate a database by clicking or double-clicking in either panel or use the arrow keys or letter keys (such as ‘T’ for table). Explore the contents of the other folders in the database.
Every Sybase IQ database contains individual folders for the following objects:
Object |
Description |
|---|---|
Dbspaces |
Additional .db, .iq, or .tmp files for the database. |
Domains |
User-defined data types. |
Events |
An action, such as a stored procedure, scheduled to be carried out at a certain time. |
Indexes |
Structures that store and represent data so that it can be used for query processing. Indexes allow quick lookup of information. In a database, the index relates each indexed column value to the physical location at which the row of data containing the indexed value is stored. |
Integrated Logins |
Login feature that allows use of the same single user ID and password for operating system logins, network logins, and database connections. |
Java Objects |
Java programming objects including packages, JAR files, and Java classes.You can install Java classes into the Catalog Store of your database. Java classes provide a way of building logic into your database. |
Join Indexes |
Tables with join indexes evaluated when accessed. |
Multiplexes |
IQ databases spread across a shared disk array, to optimize support for many users with large query loads. |
Procedures & Functions |
SQL procedures for a module-based language. |
Publications |
Identifies replicated data in SQL Remote. |
Remote Servers |
Servers connected to the local server by means of a network. |
SQL Remote Users |
Query or write servers that receive changes from other servers in a multiplex. |
System Triggers |
Triggers that modify the system tables. |
Tables |
Base tables stored in the database |
Triggers |
Special forms of stored procedure that execute only when a user runs a query that modifies the data. |
Users & Groups |
Categories for administering who is permitted to use the database. |
Views |
Computed tables, stored in the database as a query and evaluated when accessed. |
Explore the sample database until you are comfortable locating database objects in the Sybase Central main window.
