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 - .NET Programming » UltraLite .NET 1.0 API Reference » ULSyncParms class

StreamParms property Next Page

TableOrder property

Specifies the order tables should be uploaded to the consolidated database.


Visual Basic

Public Property TableOrder As String


public string TableOrder {get;set;}

Property value

A string, in the form of a comma-separated list of table names. Tables names can be quoted using either single or double quotes. The default is a null reference (Nothing in Visual Basic), which does not override the default ordering of tables.


If the foreign keys on your consolidated database match the foreign keys on your remote UltraLite database and there are no foreign key cycles, then you most likely don't need to use this feature. However, if you have tables that are part of foreign key cycles then list all tables that are part of a cycle in the TableOrder field. If you have tables with different foreign key relationships on the consolidated then also list these tables in the TableOrder field.

All tables that you don't specify will be appropriately sorted based of the foreign keys defined in the remote database.