Statements for Performing Distributed Database Maintenance
Some tasks can be accomplished using statements, which can be issued from an interactive session with SQL or ISQL, or from an application.
These statements are as follows:
• The create statement to create new tables and views in the distributed database and automatically register them
• The drop statement to remove tables and views from the distributed database
• The register as link statement to define existing tables, views, indexes, and database procedures as component objects of the distributed database
• The register as link with refresh statement to register local updates to tables, views, and indexes that are part of the distributed database
• The remove statement to remove the registration of database objects previously incorporated with the register and create statements
By default, the data definition language (DDL) statements create, drop, register, and remove are all committed immediately, independently of the user’s transaction. To learn how to turn off concurrency, see
DDL Concurrency Mode (see page
DDL Concurrency Mode).