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 HCL 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© 2019 HCL Technologies Limited