Stack Overflow
Stack Overflow

Questions tagged [data-dictionary]

A Data Dictionary stores information about all user-defined objects in the database. It usually comes with utilities to cross-reference all system components to each other.

References

187 questions
0
votes
1 answer

Include foreign keys in MySQL data dictionary

I am producing a data dictionary for a particular schema in MySQL. So far, I have the table_name, columm_name, column_type (as below in the SELECT statement). How do I include what the foreign key constraints are as well, in the same data…
user3477955
  • 91
  • 1
  • 11
0
votes
1 answer

Substitution variable seems to fail in a query to describe an oracle table

I am trying to describe a table without using the DESCRIBE command but I want to combine the query with a substitution variable. Assuming I have the following table: --DROP TABLE customers CASCADE CONSTRAINTS PURGE; CREATE TABLE customers (…
sedeh
  • 7,083
  • 6
  • 48
  • 65
0
votes
2 answers

How to use data dictionary on creating physical file for DB2 for IBM i (as400)

Can someone help me on creating a physical file where the reference field is placed in a data dictionary. how to code it in a physical file in order to link with the data dictionary. thanks in advance.
Ian Sanchez
  • 1
  • 2
0
votes
1 answer

data dictionary extraction in orientdb

I have been going over the orientdb documentation to see whether I could find something that would allow for an automatic creation of data dictionaries for existing models. In other words, my use case is that every time the nodes, edges and…
Ricardo Pietrobon
  • 808
  • 6
  • 21
0
votes
1 answer

How to get primary keys for all tables in Sybase

I have got a requirement of creating data dictionary from all the user tables in a sybase ase database. I can't install tools like Sybase PowerDesigner, and so I have to make it possible using SQL queries. I have composed this query by taking the…
Manish
  • 710
  • 3
  • 12
  • 25
0
votes
1 answer

Where is all_queue_subscribers dictionary view on oracle 9i?

11g and 10g both have the all_queue_subscribers (and user_, dba_) dictionary tables for listing the subscribers to queues, but this doesn't exist on 9i. Does the same concept of queue subscribers exist on 9i databases, and where can I get this…
thecoop
  • 45,220
  • 19
  • 132
  • 189
0
votes
1 answer

How can I find the columns of a disabled index constraint?

For a normal index constraint, you can find the columns it is on by querying the all_ind_columns sysview using the index name in all_constraints. But if the constraint is disabled, no index exists, and there doesn't seem to be anywhere else that has…
thecoop
  • 45,220
  • 19
  • 132
  • 189
0
votes
1 answer

Data dictionary mgmt - dynamically fetching list of tables in DB

I've recently faced a task to create an application for data dictionary managing (no matter if it is desktop or web app) based on DB. The main question is how to fetch list of tables dynamically (eg. admin is adding new dictionaries at the DB level,…
WBL
  • 1
0
votes
2 answers

Oracle: Table with all constraints

I am trying to create a select statement, which allows me to get an overview over all of my foreign keys. It should look like this: Table 1 | FK_Value | Table 2 | FK_Value I have figured out there must be a way with the "user_constraints" table…
user3364656
  • 279
  • 2
  • 4
  • 9
0
votes
2 answers

Data Dictionary Entries

I am in dire need of help on how to explain what a data dictionary record is... I've been on Google all night and couldn't find a thing. From a few investigations I was able to find some information, which is below, but i don't know how to link them…
Selase
  • 175
  • 5
  • 24
0
votes
1 answer

oracle query to extract data dictionary information, including primary key table and column that this foreign key is pointing to

I need to create a query in Oracle 10g for a data dictionary that extracts the following information for all the tables in a given schema: Table name Column name “P” if the column is a primary key If this column is referenced in a foreign key,…
user2996714
  • 1
  • 1
  • 2
0
votes
1 answer

Data structure for dictionary app in WP

I'm creating a dictionary app for WP. One of its features is the real-time lookup. While the use is inputing a word, the dictionary will automatically find the recommended-result that is close to what user inputed. And when the user input "bility",…
Susuri Yuyuki
  • 153
  • 1
  • 3
  • 8
0
votes
2 answers

python data dictionary out

I apologized as I am very new to python. I am iterating through out several name and they all getting the same dictionary key and value. How can i just print the key once and keep appending the value as per iteration to a csv? for name in…
user2975269
  • 13
  • 1
  • 3
0
votes
1 answer

python data dictionary output

I have a list of key and values in a data dictionary format already e.g. {'key1': 'value1', 'key2': 'value2', 'key3': 'value3'} How can this be put into a csv output where key1,key2,key3 value1,value2,value3
user2975269
  • 13
  • 1
  • 3
0
votes
2 answers

View all table contain in 'HR' Account (Oracle 11g)

SQL> select * from dba_hr_tables; select * from dba_hr_tables * ERROR at line 1: ORA-00942: table or view does not exist. Please help me out to find all table contain in HR User ... Thanks.
Gurmeet
  • 19
  • 1
  • 3
1 2 3
…
12 13