Create and drop database objects

In response to a CREATE TABLE statement, the database server executes the function that you register for am_create. If the database server does not find a function name associated with am_create, it updates the appropriate system catalog tables to reflect the attributes of the table that CREATE TABLE specifies.

If you supply a function for am_create, consider the necessity of also providing a function to drop a table that the access method creates. The database server executes the function that you register for am_drop in response to a DROP TABLE or DROP DATABASE statement. If you do not provide a function to drop a virtual table, the database server deletes any system catalog information that describes the dropped object.