

ALTER user can alter an existing object.CREATE user can create a definition object.READ user can read the structure of a definition object.The property contains a bitwise AND combination of the following privileges: The Privileges property indicates the actions the current user may carry out on the table. It introduces an additional property called Privileges. The service .Table is an extension of the service .Table. string - Table type, possible values are TABLE, VIEW, SYSTEM TABLE or an empty string if the driver does not support different table types. string - Table Description, if supported by the driver. Long - Specifies the text color for displayed text in 0xAARRGGBB notationīasic table information is included in the properties included with .Table: Long - Specifies the height of a data row. Specifies the font attributes for displayed data. String - Is an additional sort order definition. String - An additional filter for the data object, WHERE clause syntax.īoolean - Indicates if the filter should be applied. Just like queries, tables include the display properties specified in .DataSettings: The container administers Table services by name, index or as enumeration. The .XTablesSupplier interface of a Connection supplies a .Container of .Table services through its method getTables(). The following illustration shows the relationship between the .Connection and the Table objects it provides, and the services included in .Table. For details, see the sections The RowSet Service and PreparedStatement From DataSource Queries.

Use the .RowSet service, or to establish a connection to a database and use its .XCommandPreparation interface to manipulate table data. The table related services in the database context are unable to access the data in a database table. This is discussed in the section Database Design below. It is also possible to alter the table definition at the .Table service. The .Table service changes the appearance of a table and its columns in the GUI, and it contains read-only information about the table definition, such as the table name and type, the schema and catalog name, and access privileges. A .Table encapsulates tables in a Apache OpenOffice API data source.
