Create and Manage SAP Sybase IQ Databases

Use Interactive SQL or Sybase Control Center to create and manage SAP Sybase IQ databases.

• Create SAP Sybase IQ Databases
  To define your database, use SQL statements or a database design tool.
• 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.
• Disconnecting Other Users From a Database
  SAP Sybase IQ gives you the ability to disconnect other users from a given database.
• 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 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.
• Showing System Objects in Interactive SQL
  In Interactive SQL, you cannot query system tables, but you can browse the contents of a system view.
• Setting Database Options in Interactive SQL
  Database options are configurable settings that change the way the database behaves or performs.