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 logical collection of dbfiles within a database. |
Directory Access Servers |
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 |
Sometimes called user-defined data types, domains are aliases for built-in data types. |
Events |
Automate database administration, such as a stored procedure scheduled to execute out at a certain time. |
External Environments |
Refer to programming languages, utilities, and objects external to the database server. |
External Logins |
Provide access to a directory on a remote or directory access server. |
Indexes |
Structures that store and represent data 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 |
Joins that are created on sets of columns rather than individual columns, and represents a full outer join of two or more tables. |
Login Mappings |
Map a Windows user profile or Kerberos principal to an existing database user. |
Login Policies |
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 |
Identify replicated data in SQL Remote. In a Sybase IQ database, publications can only be created on SQL Anywhere tables. |
Remote Servers |
Give you access to data located on separate database servers. |
SQL Remote Subscriptions |
Creates links from a publisher to a remote database (subscriber). |
SQL Remote Users |
Define remote databases in a SQL remote setup. |
System Triggers |
Events that modify the system tables. |
Tables |
Base tables stored in the database. |
Triggers |
Execute a SQL statement or procedure automatically when someone modifies the data. |
Users & Groups |
Mechanisms that identify database users and privileges. |
Views |
Computed tables, stored in the database as a query and evaluated when accessed. |
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.
