Develop

Use Sybase WorkSpace Database Development to build your database, develop tables, table schema, and other database objects, and develop, run and debug procedural objects and SQL files.

• Develop Overview
  Use Sybase WorkSpace Database Development to build your database, create and run SQL code and SQL files, create and run procedural objects, create table schema objects, and create database views.
• Creating a Database
  You can create SQL Anywhere, Adaptive Server Enterprise, or Sybase IQ databases, which you can use for developing database applications in Sybase WorkSpace.
• Database Objects
  A database object is a component of a database used to view or manipulate data.
• Developing a Table
  Developing a table includes creating the table, editing table schema, granting table permissions, editing table data, and debugging the table.
• Developing a SQL File
  Use Database Development tools to create and update SQL files.
• Developing a Procedural Object
  Use Database Development tools to create and update procedural objects, which include stored procedures, triggers, user-defined functions, and event handlers.
• User-Defined Datatypes
  Construct your own datatypes based on the system datatypes for your data server.
• Generating Data Definition Language
  Use the Generate DDL wizard to generate DDL for database objects.
• Real-Time Messaging Services
  Real-time messaging services (RTMS) provide a way to capture transactions in an Adaptive Server Enterprise database and deliver them as events to external applications through a Java Messaging Service (JMS) message bus.
• Developing a Replication System
  Use Database Development and Replication Server to create a replication system.

---

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com