How Can I Work with Databases in Sybase WorkSpace

Create a Physical Data Model and design physical objects, such as standard database objects

Reverse engineer a database schema

Generate a database script or ODBC

Create a database to use in developing applications

Create a database service that enables connection to a database server hosting multiple databases

Create SQL files for organizing complex SQL statements

Edit procedural objects including stored procedures, triggers, and Adaptive Server Anywhere/Sybase IQ event handlers and user-defined functions

Execute procedural objects

View execution plans and results from SQL queries

Create Adaptive Server Enterprise nonsharable temporary tables

Debug procedural objects

Edit data in tables referenced in procedural objects

Create a real-time message service

Use Replication Server to perform administrative tasks, including creating and managing replication definitions, publications, articles, and subscriptions

Connect to heterogeneous data sources, such as real-time, historical, and third-party data.

Use the tooling to develop federation capabilities to combine data from these sources. Provision or search for data sources and import or create schema models to build data services.

Create a database service that enables connection to a database server hosting multiple databases

Add a stored procedure or SQL query operation to a database service

Import a SQL query for SQL operation of a database service

Develop a real-time message service