Service Table

Devguide

Index

Services' Summary

Interfaces' Summary

Properties' Summary

Services' Details

Interfaces' Details

Properties' Details

:: 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

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

API

SDK

Tips ‘n’ Tricks

Miscellaneous