Sql

Search

db2 foreign keys

select 
    ref.tabschema  concat '.' concat ref.tabname as foreign_table,
    '>-' as rel,
    ref.reftabschema concat '.' concat ref.reftabname as primary_table,
    ref.constname as fk_constraint_name
from syscat.references ref
order by foreign_table, primary_table

Comment

PREVIOUS	NEXT

Code Example
Sql :: t-sql update table variale
Sql :: how to make trigger in phpmyadmin
Sql :: narural join
Sql :: sql multiple column
Sql :: express api ith mysql data
Sql :: cassandra query example
Sql :: executescalar in sql server
Sql :: get total and distict row diff in sql
Sql :: Is there a way to use read_sql_query and the query has WHERE column = Variable?
Sql :: multiple like values for single column postgres
Sql :: and and or in where condition
Sql :: APEX elapsed time
Sql :: Having trouble running COUNT in my INSERT INTO statement
Sql :: pgsql commit rollback example
Sql :: mysql connect error
Sql :: setval postgres example table id
Sql :: python sql passer des parametres dans une requet pymysql
Sql :: can we rollback data that are deleted using DELETE
Sql :: sqlcl format
Sql :: SQL SERVER xquery count child nodes
Sql :: Filter on observations that are null SQL
Sql :: okta postgresql
Sql :: sql insert into only auto id
Sql :: modulous in sql
Sql :: How should I pass a table name into a stored proc?
Sql :: SQL Primary Key Error
Sql :: oracle rolling back
Sql :: utiliser 3 jointures mysql
Sql :: SQL CHECK Constraint in Existing Table
Sql :: coursera spark sql max count

Search

SQL

db2 foreign keys

ADD CONTENT