The drop_namespace  operator removes a namespace. Available only in the Enterprise Edition.

Synopsis

drop_namespace( name );

Summary

• Only the scidbadmin user or a user belonging to the admin role can invoke the drop_namespace operator to delete a namespace.
• A namespace cannot be deleted unless it contains no arrays.

Example

Here the scidbadmin user is running iquery in AFL mode, and removes a namespace called testNS01.

AFL% show_user();
{i} name
{0} 'scidbadmin'
AFL% drop_namespace(testNS01);
Query was executed successfully
AFL%