database-metadata Questions
26
I'm trying to figure out a way to get the underlying SQL table name for a given entity type. I've experimented around with the MetadataWorkspace queries and while I can get lots of information from...
Dehorn asked 13/12, 2009 at 3:16
5
Solved
I'm currently trying to list all columns of a specific table and determine if each column is unsigned or not.
Here, an example of my test fixture:
CREATE TABLE ttypes
(
cbiginteger BIGINT UNSIGN...
Driedup asked 19/5, 2012 at 11:49
4
Solved
How can I view the metadata(data dictionary) for a Microsoft Access 2013 table?
Housemother asked 6/7, 2014 at 4:36
17
Solved
I'm trying to find a query which will return me a list of the foreign keys for a table and the tables and columns they reference. I am half way there with
SELECT a.table_name,
a.column_name,
...
Anastice asked 13/11, 2009 at 15:37
11
Solved
Is there a fast way of getting all column names from all tables in MySQL, without having to list all the tables?
Drawers asked 13/4, 2011 at 11:27
4
I am working on a Java Application. I have connected to an Oracle DB using JDBC Connection and fetched it metadata. I am fetch information like tables, columns, views, etc from its metadata.
Now ...
Celloidin asked 3/2, 2016 at 7:38
8
Solved
I'd like to retrieve all table names from a database schema, and, if possible, get all table starting with a specified prefix.
I tried using JDBC's connection.getMetaData().getTables() but it did...
Econah asked 6/5, 2010 at 10:21
1
Solved
ASP.NET Core MVC application using EF Core. In Linq to SQL, this code returns list of database table primary key columns names:
/// <summary>
/// Database primary key names
/// </summar...
Gnome asked 21/1, 2021 at 23:18
5
Solved
This question was originally asked by @PrateekGupta
Background
@PrateekGupta wanted to perform bulk insert operation on multiple tables.
The tables have foreign key relationships between themselve...
Baun asked 2/11, 2016 at 20:10
5
I get a syntax error when I run the following:
show columns from (select * from (select * from my_table) as T)
How can I show the columns from a query that I wrote, rather than from a table?
Hibbard asked 15/9, 2010 at 9:47
4
Solved
I have inherited an existing Postgres database full of data. Most of the data has a 'created_date' column value. Some of the earlier data was inserted before this was being tracked.
Is there a Pos...
Illconditioned asked 28/2, 2012 at 19:47
1
Solved
In Postgres 10 I have declared the following:
create table test_abc (
pk integer not null,
id integer not NULL,
id2 integer not null,
PRIMARY KEY (pk)
);
CREATE UNIQUE INDEX test_abc_ids ON te...
Berth asked 16/4, 2020 at 12:1
3
I have this query to get the list of indexes on a table:
SELECT
ns.nspname as schema_name,
tab.relname as table_name,
cls.relname as index_name,
am.amname as index_type,
idx.indisprimary as i...
Ways asked 1/4, 2019 at 3:37
2
Solved
I am using the Spring JdbcUtils.extractDatabaseMetaData() method to analyze the database. The function calls a callback and hands over a DatabaseMetaData object. This object provides the getColumns...
Armillia asked 9/1, 2012 at 17:54
2
Solved
I have a table-valued function (TVF) in SQL Server that looks like this:
CREATE FUNCTION TVF_xyz(@AuditKey INT)
RETURNS TABLE
AS
RETURN
SELECT *
FROM xyz
WHERE AUDIT_KEY = @AuditKey
GO
Now,...
Palocz asked 31/3, 2017 at 1:55
4
Solved
I am trying to retrieve different kind of metadata of my Oracle DB from Java code (using basic JDBC). For example, if I want to retrieve the list of tables with _FOO suffix, I can do something like...
Phile asked 12/4, 2011 at 15:7
1
Solved
I have been mucking around with XMLs for entity Framework. I tried to create a type of entity that could have properties injected at runtime,
First I created DynamicEntity object that is dynamic
...
Cresol asked 23/6, 2016 at 15:59
5
Solved
In Oracle, is there a way to find out when a particular table was created?
Similarly, is there a way to find out when a particular row was inserted/last updated?
Cichocki asked 14/12, 2010 at 17:47
5
Solved
I am maintaining an application creating an Oracle DB via JDBC. Starting from today this query:
SELECT NULL AS pktable_cat ,
p.owner AS pktable_schem,
p.table_name AS pktable_name ,
pc.column_n...
Bowse asked 18/2, 2014 at 16:28
3
Solved
Whats the best, most consistent way to check if a table exists in NHibernate (or with Fluent-NHibernate)?
Is it even possible? I mean it seems like a simple task for such a heavy-duty ORM.
Also o...
Threonine asked 12/10, 2009 at 21:22
1
Solved
I went to an id tech camp recently and they gave us a USB with all our work but it was on a PC so I was trying to get it on my Mac and then it says file not found so I check the folders the .metada...
Axilla asked 6/7, 2015 at 4:12
1
Solved
I need to get only the procedures using java DatabaseMetaData but this method returns also the functions' names.
DatabaseMetaData dbmd=con.getMetaData();
ResultSet result = dbmd.getProcedures(null...
Selden asked 14/5, 2015 at 16:31
2
Solved
What is the difference between the ALL_TAB_COLUMNS and ALL_TAB_COLS system tables in Oracle 12c? In my DB, the ALL_TAB_COLUMNS has slightly fewer rows than ALL_TAB_COLS.
Melmon asked 6/11, 2014 at 22:8
2
How can I generate a DDL script on an existing table in oracle? I am working on a project where I have to re-create some tables that are present in Oracle table into Hive.
Slavic asked 8/10, 2014 at 5:40
1
Solved
I want to know e.g. when an entity was created or updated. Should I create an attribute like :created-at and :update-at or Datomic has theses attributes by default? Or any manner to find out when a...
Octavla asked 9/7, 2014 at 5:7
1 Next >
© 2022 - 2024 — McMap. All rights reserved.