Viewing Other Database Objects

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.