sysuldata system table

The sysuldata system table stores schema information about the UltraLite database. In previous versions, this table stored database properties and options, however users should not use this table to query these values. Instead, use the db_property() function to get the value of specific properties or options: For name, the name or identifier of the property; for type, a value that indicates the type of property or data.

Column name Column type Description
long_setting LONGBINARY A BLOB for long values.
name VARCHAR(128) The name of the property.
setting VARCHAR(128) The value of the property.
type VARCHAR(32) One of either sys for internals, opt for options, or prop for properties
 Constraints
 See also