Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Informix Request SQLWays

Informix - Instance, Database, Owner and Database Object

This article describes instance, database, owner and database object concepts in Informix Dynamic Server (IDS) 11.50 and earlier.

Instance

Informix instance is a database server software that manages one or more Informix IDS databases. Users login to an instance and access databases and database objects (tables, views, procedures etc).

Database

Informix database contains various database objects such as tables, views, store procedures etc.

Owner

In Informix, every database object has an owner, a user who created this object.

Database Object

Database object is a table, view, procedure or any other type of objects supported by Informix. Database objects are created using a SQL CREATE statement for these types of objects, and have owners.

Referencing Database Objects in Informix
[database[@server_name]:][owner.]object

For example, stock table located in the stores database and owned by informix user

stores:informix.stock


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Informix Request SQLWays

sqlways/informix/instance-database-owner-object.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement