1. Scott Roberts
  2. Valentina Database ADK
  3. Понедельник, Июль 16 2018, 11:04 PM
  4.  Подписаться через 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.
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
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?
Комментарий
There are no comments made yet.
Scott Roberts Ответ принят
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.
Комментарий
There are no comments made yet.
  • Страница :
  • 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