Is there a way using SQL to list all foreign keys for a given table? I know the table name / schema and I can plug that in.
Sql – How to list table foreign keys
postgresqlsql
Related Topic
- Sql – How to list all foreign keys referencing a given table in SQL Server
- Sql – Insert results of a stored procedure into a temporary table
- Sql – Postgres and Indexes on Foreign Keys and Primary Keys
- Sql – How to get column names from a table in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql – Finding duplicate values in a SQL table
Best Answer
You can do this via the information_schema tables. For example: