TableOrder property

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

Syntax

Visual Basic

Public Property TableOrder As String

C#

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.

Remarks

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.