Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLite - Database Management and Reference » Using UltraLite Databases » Working with UltraLite databases » Working with UltraLite publications


Publishing whole tables in UltraLite

The simplest publication you can make consists of a single article, which consists of all rows and columns of a table.

You can use either Sybase Central or Interactive SQL to perform this task.

Sybase Central

In Sybase Central, you can perform this task while working with the connected database.

♦  To publish one or more whole UltraLite tables (Sybase Central)
  1. Connect to the UltraLite database.

  2. Right-click the Publications folder, and choose New » Publication.

  3. In the What Do You Want To Name The New Publication field, type a name for the new publication. Click Next.

  4. On the Tables tab, select tables from the Available Tables list. Click Add.

  5. Click Finish.

Interactive SQL

In Interactive SQL, you can perform this task with the CREATE PUBLICATION statement.

♦  To publish one or more whole UltraLite tables (Interactive SQL)
  1. Connect to the UltraLite database.

  2. Execute a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.

    For example, the following statement creates a publication that publishes the whole customer table:

    CREATE PUBLICATION pub_customer (
       TABLE customer
See also