Using Sybase Central to work with database objects

Sybase Central is the primary tool for working with database objects on windowing systems. You can use Sybase Central to manage servers, databases, and dbspaces. It lets you create, modify, and delete all kinds of database objects, including query servers, tables, procedures, views, indexes, users and groups.

If you use the Sybase IQ multiplex feature, Sybase recommends that you use Sybase Central to manage database objects. In a multiplex, Sybase Central enables easy creation query servers and dbspaces, and also lets you start and shut down servers. For more information about the multiplex feature, see “Multiplex capability”. DML and DDL statements are the same for multiplex and non-multiplex Sybase IQ databases, except for a few restrictions described in “Updating multiplex databases” and “Multiplex management without Sybase Central”.

This chapter is concerned with the SQL statements for working with database objects. If you use Sybase Central, these SQL statements are generated for you. The primary source of information about Sybase Central is the Sybase Central online Help. This chapter gives only brief pointers for tasks that you can carry out using Sybase Central.

For an introduction to using Sybase Central, see Chapter 4, “Managing Databases” in Introduction to Sybase IQ.