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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Working with UltraLite Databases » Working with UltraLite publications

Working with UltraLite publications Next Page

Publishing whole UltraLite tables


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. Open the Publications folder.

  3. Create the publication.

    Choose File > New > Publication. The Create Publication wizard appears.

  4. Enter a name for the new publication, and click Next.

  5. On the Tables tab, select a table from the list of Available Tables. Click Add. The table appears in the list of Selected Tables on the right.

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

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

    Example    The following statement creates a publication that publishes the whole customer table:

    CREATE PUBLICATION pub_customer (
       TABLE customer
    )
  3. See also