Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1280
  • Last Modified:

Materialized views in sybase

Once the Materialized views are created, where can we see the code of the materialized view  which i created, I'm unable to see the code as we can see when we create the views.

when i query the materialized view i could see the data, but i want to update the materialized view, but i'm not finding the location where its saved?

can anyone suggest
0
novicesybase
Asked:
novicesybase
  • 2
2 Solutions
 
alpmoonCommented:
According to Sybase manuals you can run below query to see materialzed views:

SELECT b.object_id, b.table_name, a.option_id, c.option_name, a.option_value
FROM SYSMVOPTION a, SYSTAB b, SYSMVOPTIONNAME c
WHERE a.view_object_id=b.object_id
AND b.table_type=2;

Refer:

http://dcx.sybase.com/1200/en/dbusage/ug-workingwdb-s-3550400.html
0
 
Joe WoodhousePrincipal ConsultantCommented:
Which Sybase database product are you using?

The above code is good only for ASA. (Can ASA do materialised views? Unsure.)

I suspect you mean ASE, in which case a simple

    sp_helptext <view name>
    go

in the database you created the view should show you its definition. This is true for every compiled object that is stored separately (like stored procedures, triggers and views).
0
 
Pariksiht SonaikarCommented:
Please give me any example to create materialised view in sybase ase 16. If it is not supported to that DB, please let me know.
0
 
Joe WoodhousePrincipal ConsultantCommented:
Hello, I see you've asked this question in a new top-level question, which is the correct way to do this (rather than asking new questions in somebody else's question). I have answered you there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now