Home | Previous Page | Next Page   Descriptor Function Reference > Accessor Functions >

mi_tab_owner()

The mi_tab_owner() function retrieves the owner of the table.

Syntax

mi_string* mi_tab_owner(MI_AM_TABLE_DESC *tableDesc)
tableDesc
points to the table descriptor.

Usage

The user who creates a table owns that table. The database server identifies the owner by user ID, which it stores in the systables system catalog table. In some environments, user ID of the table owner must precede the table name as follows:

SELECT * from owner.table_name

Return Values

The string contains the user ID of the table owner.

Related Topics

See the description of the Owner Name segment in the IBM Informix: Guide to SQL Syntax.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]