Database Definition

To define your database, you can use SQL statements or you can use a database design tool.

Some application design systems, such as Sybase PowerDesigner®, contain facilities for creating database objects. These tools construct SQL statements that are submitted to the server, typically through its ODBC interface. If you are using one of these tools, you do not need to construct SQL statements to create tables, assign permissions, and so on.

Database design tools such as Sybase PowerDesigner provide a thorough and reliable approach to developing well-designed databases.

• Database Creation with SQL
  You can use SQL statements for defining database objects directly if you build your database from an interactive SQL tool, such as dbisql.
• Setting Database Options in Sybase Central
  Database options are configurable settings that change the way the database behaves or performs.
• Setting Database Options in Interactive SQL
  Database options are configurable settings that change the way the database behaves or performs.
• IQ Main Store and IQ Temporary Store Space Management
  Options MAIN_RESERVED_DBSPACE_MB and TEMP_RESERVED_DBSPACE_MB provide room for checkpoint, commit, and release savepoint operations.
• Showing System Objects in Sybase Central
  In a database, a table, view, stored procedure, or domain is a system object.
• Showing System Objects in Interactive SQL
  In Interactive SQL, you cannot query system tables, but you can browse the contents of a system view.
• Disconnecting from a Database in Sybase Central
  When you are finished working with a database, you can disconnect from it.
• Disconnecting All Connections from a Database in Interactive SQL
  When you are finished working with a database, you can disconnect a named connection or all connections.
• Disconnecting from a Database in Embedded SQL
  When you are finished working with a database, you can disconnect a named connection or all connections.
• Disconnecting Other Users From a Database
  Sybase IQ also gives you the ability to disconnect other users from a given database.
• Dropping a Database
  Dropping a database deletes all tables and data from disk, including the transaction log that records alterations to the database. It also drops all of the dbspaces associated with the database.