View area

  1. Select a schema from your connected database.
  2. View name
  3. Search button for searching a view inside of a selected schema.
    For searching you have to connect to a database, select a schema and enter a view name.
  4. The selected user will create/recompile the view.
  5. Enter your view select statement in the View DDL. Look to it that you do not forget to enter the viewalyzer schema before table, view etc. else you get a recompile error.

    Example:

    Schema viewalyzer
    View v_view

    View DDL: SELECT * FROM viewalyzer.v_view;