Deleting multiversioned views

To remove a multiversioned view from the database, use the sdetable command with the delete_mv_view operation.

CautionCaution:

Do not use Structured Query Language (SQL) to drop your multiversioned view.

Steps:
  1. To delete a multiversioned view named parcels_mv that was created on a table named parcels, use the sdetable command with the delete_mv_view operation. Examples for each DBMS are shown here.
    • IBM DB2
      sdetable –o delete_mv_view –t parcels
      -i sde:db2 –D landbase –u bjorn –p a.secret
    • IBM Informix
      sdetable –o delete_mv_view –t parcels 
      -i sde:informix –D landbase –u bjorn –p a.secret
    • Oracle
      sdetable –o delete_mv_view –t parcels 
      -i sde:oracle11g –u bjorn@ora11sv –p a.secret
    • PostgreSQL
      sdetable –o delete_mv_view –t parcels 
      -i sde:postgresql:server1 –D landbase –u bjorn –p a.secret
    • Microsoft SQL Server
      sdetable –o delete_mv_view –t parcels 
      -i sde:sqlserver:myserver\sqlinstance –D landbase –u bjorn –p a.secret

    For complete syntax information for the sdetable command, see the ArcSDE Administration Command Reference provided with the ArcSDE component of ArcGIS Server Enterprise.

    TipTip:

    If you are using ArcSDE for PostgreSQL and accidentally drop your multiversioned view at the SQL prompt rather than using sdetable –o delete_mv_view, use the sde_clean_rule_functions to unreference the rule functions.

    SELECT sde_clean_rule_functions();

Related Topics


2/5/2013