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
80
votes
3 answers

Check Postgres access for a user

I have looked into the documentation for GRANT Found here and I was trying to see if there is a built-in function that can let me look at what level of accessibility I have in databases. Of course there is: \dp and \dp mytablename But this does not…
ryekayo
  • 2,341
  • 3
  • 23
  • 51
51
votes
3 answers

Is there a way to do full text search of all oracle packages and procedures?

I would like to search through all of my procedures packages and functions for a certain phrase. Since it is possible to retrieve the code for compiled procedures using toad I assume that the full text is stored in some data dictionary table. Does…
George Mauer
  • 117,483
  • 131
  • 382
  • 612
29
votes
4 answers

How to get list of all the procedure inside a package oracle

Can I get the name of all the function inside a package. Suppose I have a package PKG_OWA and I want to list all the procedure inside the package.
शेखर
  • 17,412
  • 13
  • 61
  • 117
24
votes
7 answers

lower_case_table_names Settings in MySQL 8.0.12

I've just compiled the version MySQL 8.0.12 in a Ubuntu 16.0.4. After following the instructions in the website and making the following my.cnf…
asuka
  • 2,249
  • 3
  • 22
  • 25
20
votes
3 answers

How to close the file after pickle.load() in python

I saved a python dictionary in this way: import cPickle as pickle pickle.dump(dictname, open("filename.pkl", "wb")) And I load it in another script in this way: dictname = pickle.load(open("filename.pkl", "rb")) How is it possible to close the…
user2961420
  • 267
  • 1
  • 3
  • 8
11
votes
3 answers

Is there a dictionary or database of English words with each word separated by syllables?

I am looking for an existing database of English words with each word separated by syllables. My purpose is to further edit each word in any selected article based on the separation of syllables. Does anyone know an existing product or method that…
vicky
10
votes
4 answers

Generating data dictionary for SQL Server database

I am trying to generate a data dictionary for a table in my database. Ideally I would like to export the column names, data type, restrictions and extended property descriptions. How can this be achieved?
Anthony
  • 249
  • 1
  • 5
  • 15
9
votes
2 answers

Oracle equivalent of information_schema.tables

I get a "table or view does not exist" error while I try to execute the query below in Oracle: SQL QUERY SELECT table_type, table_name FROM information_schema.tables WHERE table_rows >= 1; ERROR ORA-00942: table or view does not exist How…
Arun
  • 107
  • 2
  • 2
  • 10
8
votes
2 answers

Data Dictionary generators for PostgreSQL to Confluence Wiki

I'm looking for a tool that takes PostgreSQL tables and outputs a Data Dictionary in a wiki format (preferably Confluence). It seems like most tools out there require a lot of manual work/multiple tools to accomplish this task (IE> SchemaSpy, DB…
Matt
  • 81
  • 1
  • 2
8
votes
2 answers

How To Refresh Data Dictionary in Oracle?

i deleted some of my tables in oracle DROP TABLE hr.admin_emp CASCADE CONSTRAINTS; but the primary key constraint of deleted table is still in data dictionary (all_constraints). now my question is how to update data dictionary so it does not show…
jalal rasooly
  • 705
  • 3
  • 7
  • 24
7
votes
2 answers

Why is my plsql code missing in the datadictionary in Oracle 12c?

Can anyone please shed some light on what might be wrong with my 12c laptop-installation to cause the following problem? In short: All the code I create in my schema is there and can be executed, but can not be viewed or edited in any IDE, or via…
Erik van Roon
  • 91
  • 1
  • 7
7
votes
1 answer

Query columns names from a table from another user

Sounds pretty easy query the column names from a table, right? Indeed there is a answer to this question How can I get column names from a table in Oracle? The main issue is that the table belongs to another user. My user is just for integration and…
Custodio
  • 8,594
  • 15
  • 80
  • 115
6
votes
5 answers

What tools are available to document a legacy database schema (PDF, DOC, HTML, RTF)

I need to document a legacy database schema for a new employee and as there's no design document I'd like to generate one from the existing schema. As the tables are MyISAM the foreign key relationships won't produce a nice graph. I'm interested in…
BenM
  • 4,056
  • 3
  • 24
  • 26
6
votes
9 answers

Do you generate your data dictionary?

Do you generate your data dictionary? If so, how? I use extended procedures in SQL Server 2005 to hold onto table and field information. I have some queries that create a dictionary out of them, but it's ... meh. Do you have a particular query or…
nathaniel
  • 1,135
  • 2
  • 8
  • 20
5
votes
3 answers

Text segmentation: dictionary-based word splitting

Background Split database column names into equivalent English text to seed a data dictionary. The English dictionary is created from a corpus of corporate documents, wikis, and email. The dictionary (lexicon.csv) is a CSV file with words and…
Dave Jarvis
  • 30,436
  • 41
  • 178
  • 315
1
2 3
…
12 13