:: com :: sun :: star :: sdbcx ::

service Table
Description
used to specify a table in a database. A table is described by its name and one or more columns.

In addition, it may contain indexes to improve the performance in the retrieval of the table's data and keys, and to define semantic rules for the table.

Note: All properties and columns of a table could by modified before it is appended to a database. In that case, the service is in fact a descriptor. On existing tables, a user might alter columns, add or delete columns, indexes, and keys depending on the capabilities of the database and on the user's privileges.

See also
::com::sun::star::sdbc::XDatabaseMetaData, Privilege

Exported Interfaces - Summary
XDataDescriptorFactory

optional, could be used to copy an table. (details)

XColumnsSupplier

access to the contained table columns.

XIndexesSupplier

optional, provides the access of the table indexes. (details)

XKeysSupplier

optional, provides the access to the table keys. (details)

XRename

optional, allows the renaming of tables. (details)

XAlterTable

optional, allows the altering of columns. (details)

::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
Properties' Summary
[ readonly ] string
Name
is the name of the table.  
[ readonly ] string
CatalogName
is the name of the table catalog.  
[ readonly ] string
SchemaName
is the name of the table schema.  
[ readonly ] string
Description
supplies a comment on the table. Could be empty, if not supported by the driver.  
[ readonly ] string
Type
[ OPTIONAL ]
indicates the type of the table like (TABLE, VIEW, SYSTEM TABLE). Could be empty, if not supported by the driver.  
Exported Interfaces - Details
XDataDescriptorFactory
Usage Restrictions
optional
Description
optional, could be used to copy an table.
XColumnsSupplier
Description
access to the contained table columns.
XIndexesSupplier
Usage Restrictions
optional
Description
optional, provides the access of the table indexes.
XKeysSupplier
Usage Restrictions
optional
Description
optional, provides the access to the table keys.
XRename
Usage Restrictions
optional
Description
optional, allows the renaming of tables.
XAlterTable
Usage Restrictions
optional
Description
optional, allows the altering of columns.
::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
Properties' Details
Name
[ readonly ] string Name;
Description
is the name of the table.
CatalogName
[ readonly ] string CatalogName;
Description
is the name of the table catalog.
SchemaName
[ readonly ] string SchemaName;
Description
is the name of the table schema.
Description
[ readonly ] string Description;
Description
supplies a comment on the table. Could be empty, if not supported by the driver.
Type
[ readonly ] string Type;
Usage Restrictions
optional
Description
indicates the type of the table like (TABLE, VIEW, SYSTEM TABLE). Could be empty, if not supported by the driver.

 
Top of Page