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

SQL Anywhere 11.0.0 » 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.

    The Create Publication Wizard appears.

  3. Type a name for the new publication, and click Next.

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

    The table appears in Selected Tables on the right.

  5. Optionally, you may add additional tables. The order of the tables is not important.

  6. 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