Top "Data-dictionary" questions

A Data Dictionary stores information about all user-defined objects in the database.

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 …

postgresql privileges data-dictionary
How can I describe a table in Oracle without using the DESCRIBE command?

I'm having a hard time with a class I am taking. We need to write an Oracle script that will …

oracle oracle11g sql-scripts data-dictionary
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 …

oracle plsql data-dictionary
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 …

sql-server sql-server-2008 data-dictionary
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 …

mysql lowercase data-dictionary
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 …

python pickle data-dictionary
How can you tell which columns are unused in ALL_TAB_COLS?

When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as …

oracle oracle9i data-dictionary
How can one programmatically find the current Oracle patch set?

In Identifying Your Oracle Database Software Release Oracle states that you can find your "platform-specific release number" (patch set) by …

sql oracle versioning data-dictionary
Utility to create "data dictionary" for MySQL database

I'm wondering if there is a utility that exists to create a data dictionary for a MySQL database. I'm considering …

mysql sql data-dictionary
Query SQL Server data dictionary to find all databases containing table 'x'

I'm not overly familiar with the SQL Server data dictionary, but I've assumed what I'm trying to do is possible. …

sql sql-server data-dictionary