A table hierarchy allows you to construct a SELECT, UPDATE, or DELETE statement whose scope is a supertable and its subtables--in a single SQL command. For example, a query against any supertable in a table hierarchy returns data for all columns of the supertable and the columns that subtables inherit from the supertable. To limit the results of a query to one table in the table hierarchy, you must include the ONLY keyword in the query. For more information about how to query and modify data from tables in a table hierarchy, see the IBM Informix: Guide to SQL Tutorial.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]