Create and Manage SAP Sybase IQ Databases
Use Interactive SQL or SAP 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.
Created November 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com