Table Creation

After the root dbspace exists, and a database has been created, users with the necessary SQL privileges can create a database table. When users create a table, the database server allocates disk space for the table in units called extents (see what is an extent in the chapter on where data is stored in the IBM® Informix® Administrator's Guide). The paragraphs that follow describe the major events that occur when the database server creates a table and allocates the initial extent of disk space.

Copyright© 2018 HCL Technologies Limited