data-dictionary Questions
5
Solved
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 b...
Doall asked 27/6, 2011 at 1:37
7
Solved
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 file:
[mysqld]
datadir=/usr/local/mysql/data
socket...
Evermore asked 11/8, 2018 at 19:53
3
Solved
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 ...
Seine asked 13/11, 2014 at 20:11
3
Solved
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("fi...
Variety asked 20/11, 2013 at 16:11
2
Solved
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;
...
Gale asked 7/3, 2019 at 6:35
4
Solved
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.
Arin asked 28/12, 2011 at 9:37
2
Solved
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,...
Jodhpur asked 10/1, 2015 at 19:14
3
Solved
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 syllab...
Embarrassment asked 20/1, 2009 at 1:45
9
Solved
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 t...
Amphitrite asked 11/11, 2008 at 19:59
2
Solved
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 ...
Mckean asked 20/1, 2014 at 9:26
2
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 ...
Smithers asked 7/7, 2011 at 17:23
1
Solved
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...
Brigadier asked 7/6, 2012 at 18:58
3
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 d...
Interlude asked 2/1, 2011 at 22:32
5
Solved
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 re...
Messuage asked 13/5, 2009 at 17:19
1
Solved
Unfortunately the BOL is a little vague on this, but index_id = 0 on sys.indexes or sys.partitions appears to refer to the table itself where there is no clustered index on the table. True - or am ...
Reprovable asked 18/1, 2009 at 21:49
3
Solved
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 ...
Salve asked 30/10, 2008 at 21:53
1
© 2022 - 2024 — McMap. All rights reserved.