Skip to main content

SqlColumnNumber (Property Keyword)

Specifies the SQL column number for this property. Applies only to persistent classes.

Usage

To specify the SQL column number for the property, use the following syntax:

Property name As classname [ SqlColumnNumber = 4 ]; 

Where n is a number between 2 and 4096, inclusive.

Details

This keyword lets you explicitly set the SQL column order for this property. The SQL column order is used when querying the table through a SELECT * statement, or using an INSERT or LOAD DATA command without specifying the column order explicitly.

Setting this property keyword enables you to decouple the order implied by your class definition from the SQL projection of this class as a table.

Default

The default is an empty string.

See Also

FeedbackOpens in a new tab