Replacing Object Definitions

Replace existing object definitions with new definitions while preserving the original name, object ID, auditing options, and permissions.

The create or replace functionality creates a new object, or replaces an existing object with the same name. The or replace clause allows SAP ASE to implicitly drop and re-create an existing object of the same name and type within the database. The or replace clause changes the definition of the object, but preserves existing security attributes such as permissions and auditing options, allowing you to avoid having to save granted permissions and re-grant the permissions after the object is dropped and created.