Seems I’m not even able to get a clean list of tables from the
Virtuoso/Database/SQL Database Objects ->
Export Schema tool. I’ve requested only
Table Definitions and
Foreign Keys (disabling the checkboxes for
Stored Procedures and
Views), but I’m still getting my Procedure Views being exported.
That’s a LOT of noise in my export. Is there a way to eliminate Procedure Views from that export? Have I missed an obvious step?
An example might help… this is the Procedure View that I’ve created for accessing a Stored Procedure that parses out analytics system:
create procedure view WEBSTATS.EXTRANET.REPORT_01 as WEBSTATS.EXTRANET.PARSE_REPORT_01(
grant execute on WEBSTATS.EXTRANET.REPORT_01 to EXTRANET;
When I export the
Table Definitions from the
Export Schema utility in Conductor, I see this definition:
create table "WEBSTATS"."EXTRANET"."REPORT_01"
That’s not an actual table, it’s just a Procedure View. The table def shown above is the mirror image of the Procedure View’s output columns.