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 |
A dbspace is a logical collection of dbfiles within a database. |
Directory Access Servers |
A directory access server gives you access to the local file system of the computer running the database server. You can create proxy tables for the directory access server to access the files and directories on the server computer. |
Domains |
Domains, sometimes called user-defined data types, are aliases for built-in data types. |
Events |
Events automate database administration. An event can be an action, such as a stored procedure, scheduled to be carried out at a certain time. |
External Environments |
External environments refer to programming languages, utilities, and objects external to the database server. |
External Logins |
External logins provide access to a directory on a remote or directory access server. |
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. |
Join Indexes |
Tables with join indexes evaluated when accessed. |
Login Mappings |
Login Mappings map a Windows user profile or Kerberos principal to an existing database user. |
Login Policies |
A login policy is a set of options that define rules to be applied when a user connects to a database. |
Procedures & Functions |
SQL procedures for a module-based language. |
Publications |
Identifies replicated data in SQL Remote. In a Sybase IQ database, publications can only be created on SQL Anywhere tables. |
Remote Servers |
Remote servers give you access to data located on separate database servers. |
SQL Remote Subscriptions |
A SQL Remote subscription creates links from a publisher to a remote database (subscriber). |
SQL Remote Users |
Remote users define remote databases in a SQL remote setup. |
System Triggers |
Triggers that modify the system tables. |
Tables |
Base tables stored in the database. |
Triggers |
Triggers allow you to have a SQL statement or procedure invoked automatically when someone 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. |
Web Services |
Web services describe how to process HTML and XML requests made to the web server. |
Explore the demo database until you are comfortable locating database objects in the Sybase Central main window.
