1. Scott Roberts
  2. Valentina Database ADK
  3. Monday, July 16 2018, 11:04 PM
  4.  Subscribe via email
Does Valentina provide access to system tables, such as Oracle's ALL_TABLES, ALL_TAB_COLUMNS, etc.?

When I change parameters to a stored procedure/function, I sometimes need to run a query to see where the stored procedure/function is referenced.
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer
1. There are few statements to investigate the schema like


SHOW DATABASES;
SHOW TABLES;
SHOW COLUMNS OF TABLE ....

SHOW PROPERTIES OF DATABASE;
SHOW PROPERTIES OF TABLE ...


2. There are 2 hidden linked system tables which keep the db schema - "sysitem" and "sysItemDescription"


3. Internally, vKernel builds something like "dependency graph", but it looks there is no way to get it via SQL.
Could you provide some example how do you want to see such dependencies and put it to the Mantis as a feature request?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Scott Roberts Accepted Answer
I created a Mantis ticket (8315) requesting the ability to add a WHERE clause to the SHOW... commands.

Then I found the SHOW Statements documentation and saw the example in the SHOW as Sub-Query section. This is what I need.

I was unable to find a way to delete the Mantis ticket, so it can be marked as closed / already implemented.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories