Kingbasees database administrator's Guide -- 15.4 Data dictionary view of views, synonyms, and sequences

You can query the specified data dictionary view , Learn about views 、 Synonym and sequence information .

The following view records the display about the view 、 Synonym and sequence information :

• Query of view information

View as a database object , The relevant information is stored in the data dictionary .

• Query of sequence information

Sequence as a database object , The relevant information is stored in the data dictionary .

• Query of synonym information

Synonyms as a database object , The relevant information is stored in the data dictionary .

Parent theme ：  Manage views 、 Sequences and synonyms

15.4.1.  Query of view information

View as a database object , The relevant information is stored in the data dictionary .

There are three views related to views ：

• USER_VIEWS, View information about the current user

• DBA_VIEWS, All view information in the system

• ALL_VIEWS, All view information that the current user can access

For example, to query a view stu_age_view Information about , You can perform the following SELECT sentence ：

SELECT text FROM user_views WHERE view_name = 'stu_age_view';

among text What is stored in is what is used when creating views SELECT sentence .

Parent theme ：  View 、 Data dictionary view of synonyms and sequences

15.4.2.  Query of sequence information

Sequence as a database object , The relevant information is stored in the data dictionary .

There are three views related to sequences ：

• USER_SEQUENCES, Sequence information about the current user

• DBA_SEQUENCES, All sequence information in the system

• ALL_SEQUENCES, All sequence information that the current user can access

For example, if you need to know stu_sequence Sequence information , You can perform the following SELECT sentence ：

SELECT min_value,max_value,increment_by,last_number,cycle_flag
FROM dba_sequences
WHERE sequence_name = 'stu_sequence';
-- perhaps 
SELECT *
FROM dba_sequences
WHERE sequence_name = 'stu_sequence';

Parent theme ：  View 、 Data dictionary view of synonyms and sequences

15.4.3.  Query of synonym information

Synonyms as a database object , The relevant information is stored in the data dictionary .

There are three views related to synonyms ：

• USER_SYNONYMS, Synonym information about the current user

• DBA_SYNONYMS, All synonym information in the system , Include synonyms created by each user

• ALL_SYNONYMS, All synonym information that the current user can access , Including private and common synonyms

To query the synonyms created by the current user , Each represents the object of that user , You can perform the following SELECT sentence ：

SELECT synonym_name,table_name,table_owner
FROM user_synonyms;

If you want to query in the whole database system User created synonyms , You can perform the following SELECT sentence ：

SELECT synonym_name,table_name,table_owner
FROM dba_synonyms;
WHERE owner='system';

SELECT synonym_name,table_name,table_owner
FROM dba_synonyms;
WHERE owner='PUBLIC';

Parent theme ：  View 、 Data dictionary view of synonyms and sequences