Top "Database-metadata" questions

Metadata is "data about data". In database terminology, this set of metadata is referred to as the catalog.

List of foreign keys and the tables they reference in Oracle DB

I'm trying to find a query which will return me a list of the foreign keys for a table and …

oracle metadata database-metadata
How to get all columns' names for all the tables in MySQL?

Is there a fast way of getting all column names from all tables in MySQL, without having to list all …

mysql database-schema database-metadata
How to find out when a particular table was created in Oracle?

In Oracle, is there a way to find out when a particular table was created? Similarly, is there a way …

oracle oracle11g database-metadata
How to get all table names from a database?

I'd like to retrieve all table names from a database schema, and, if possible, get all table starting with a …

java database jdbc database-metadata
How can I get different datatypes from ResultSetMetaData in Java?

I have a ResultSet that returns data of different types. The query is constructed dynamically so, at compile time, I …

java jdbc metadata database-metadata
Get Database Table Name from Entity Framework MetaData

I'm trying to figure out a way to get the underlying SQL table name for a given entity type. I've …

.net entity-framework database-metadata
How can I generate (or get) a ddl script on an existing table in oracle? I have to re-create them in Hive

How can I generate a DDL script on an existing table in oracle? I am working on a project where …

sql oracle ddl database-metadata
JDBC DatabaseMetaData.getColumns() returns duplicate columns

I'm busy on a piece of code to get alle the column names of a table from an Oracle database. …

java jdbc database-metadata
How to find out when data was inserted to Postgres?

I have inherited an existing Postgres database full of data. Most of the data has a 'created_date' column value. …

postgresql database-metadata
Copy a mysql table content from one server to another server

How to copy a table from server A database db1 to server B database db2 ? I am able to copy …

php mysql database-metadata