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
5
votes
1 answer

Export Data Dictionary of my database using MySQL Workbench CE?

I have a database on server with around 60 tables and now I want to export Data Dictionary of the database (including table structures).. I can do that on my local machine which has PHPMyAdmin, however, I am not able to find way to export it on…
Ghazanfar Mir
  • 3,493
  • 2
  • 26
  • 42
5
votes
2 answers

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 querying PRODUCT_COMPONENT_VERSION: To identify the release of Oracle Database that is currently installed…
Ben
  • 51,770
  • 36
  • 127
  • 149
5
votes
4 answers

Read SQL Table into Dictionary>

I have a SQL table that looks like this: AAA, Amanda, Anthony AAA, Anna, Andrew BBB, Boris, Benji BBB, Blondie, Bobby I'm trying to use a SQL data reader to read the data then insert the results into a Dictionary> The…
Administrateur
  • 891
  • 4
  • 13
  • 29
4
votes
4 answers

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 just writing a php script that fetches the meta data about the database and displays it in a logical format for users to understand…
Casey Flynn
  • 13,654
  • 23
  • 103
  • 194
4
votes
2 answers

postgresql: for a given table name what is schema name?

I have a table name student and like 35 schemas in my DB. how can i get in which schema the table student exists? (there might be more than one in different schemas). I've tried through pg_class but I don't know how to get schema name from there.
John
  • 1,724
  • 6
  • 25
  • 48
4
votes
2 answers

MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist

Recently I have updated from MySQL 5.1 to 5.5 and after few weeks the following error message was displayed each time I access the phpMyAdmin application: 1146 - Table 'data_dictionary.CHARACTER_SETS' doesn't exist I have investigated the issue to…
Simeon Mitev
  • 53
  • 2
  • 5
4
votes
2 answers

What are the Best Practices to follow while creating a data-dictionary?

I have large and complex SQL Server 2005 DB used by multiple applications. I want to create a data-dictionary for maintaining not only my DB objects but also cross-reference them against applications that use a specific object. For example, if a…
Cyclop
3
votes
1 answer

Trying to create Db doc from sql developer and it successfully works but when i click on index.html no file found

I am trying to extract a data dictonary from the sql developer.I made sure that i was connect to the database and i am able to write queries and get output. Then i go to generate a db doc it shows successfull and then when i go to the folder and…
Unknown
  • 41
  • 3
3
votes
2 answers

find all the columns of a database with %latin1% value

How could I do this SQL query? Name Database: database_1 Column: Collation Value: latin1_swedish_ci I need the list of ALL "database_1" tables that have columns whose value contains the text %latin1%. My final goal: I need to change these values in…
Chay
  • 43
  • 4
3
votes
1 answer

Creating a data dictionary in Dataiku

I would like to create a data dictionary for all the tables and columns that I have imported in my Dataiku project. For example, in SAS there are SASHELP.VCOLUMN and .VTABLE that covers such functionality. Is there a smart way to do it in Dataiku?
kacperdominik
  • 194
  • 2
  • 10
3
votes
1 answer

Does index_id=0 in sys.indexes refer to the table itself?

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 I missing something?
ConcernedOfTunbridgeWells
  • 64,444
  • 15
  • 143
  • 197
3
votes
1 answer

Find tables accessed by user in Oracle

Using Oracle XE 10g. We have an application that uses a database user with restricted access. Because it is very cumbersome to find out by trial and error which tables this user needs to have access to, we are looking for a way to query the Oracle…
wvdz
  • 16,251
  • 4
  • 53
  • 90
3
votes
2 answers

New Oracle Database

When I create an Oracle database it has a lot of tables in it with strange names. What are these tables? Should I keep them? If not, how can I avoid creating them? These are the table names: LOGMNR_UID$ LOGMNR_SESSION_EVOLVE$ LOGMNR_GLOBAL$ …
Shayan
  • 2,758
  • 7
  • 36
  • 55
3
votes
2 answers

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 the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the…
thecoop
  • 45,220
  • 19
  • 132
  • 189
3
votes
1 answer

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. We have a number of replicated databases, under different names say: Client1 Client2 Client3 Rather than rely on a naming convention, I…
MattH
  • 4,166
  • 2
  • 29
  • 33
1
2
3
…
12 13