[
https://issues.apache.org/jira/browse/DERBY-6846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas closed DERBY-6846.
--------------------------------
Resolution: Invalid
Gentle reminder: In the future, please post informational questions like this
to [email protected] or [email protected].
The following query prints a row for every column which was declared as
GENERATED ALWAYS AS IDENTITY or as GENERATED BY DEFAULT AS IDENTITY:
{noformat}
select t.tableid, s.schemaname, t.tablename, c.columnname
from sys.systables t, sys.sysschemas s, sys.syscolumns c
where t.schemaid = s.schemaid
and c.referenceid = t.tableid
and c.autoincrementinc is not null;
{noformat}
> query to find tablename and their identity column name
> ------------------------------------------------------
>
> Key: DERBY-6846
> URL: https://issues.apache.org/jira/browse/DERBY-6846
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.11.1.1, 10.12.1.1
> Environment: centos
> Reporter: Anjana
>
> Hi,
> Is there a query available in derby to get table name and their column name
> which is of type identity.
> Appreciate if any guidance on same.
> Thanks,
> Anjana.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
