Little help with SQL

Question

So I've been workin with SQL recently and ran into a lot of problems, mostly solved them by myself but stuck with this one. I've created a table and added foreign key constraint to a column in a table. So far everything worked perfectly and didn't cause error. But when i see table description, i can't see the foreign key constraint mentioned next to the column name i applied it to. I know it's applied to that column successfully but just in case i forget it in the future, how do I see all the constraints applied in the columns of a table? Table description certainly doesn't show everything. So what do I do?

Answer 1

I found INFORMATION_SCHEMA.TABLE_CONSTRAINTS

https://www.geeksforgeeks.org/sql-query-to-display-all-the-existing-constraints-on-a-table/

https://www.postgresql.org/docs/current/infoschema-table-constraints.html

https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-table.html

Answer 2

Simon Sauter wow awesome! I tried for a long time and didn't get it. thank you very much :)

Answer 3

SoloProg thank you but I'm using an Android device to do all these😅

Answer 4

Toad®

Toad by Quest is a database management toolset that database developers, administrators and data analysts use to simplify workflows, create high quality code free from defects, automate frequent or repetitive processes, and minimize risks. Millions of users trust Toad for their most critical systems and data environments. By enabling a proactive approach to database management, Toad allows teams to focus on more strategic initiatives and move the business forward in today’s data-driven economy.

https://www.quest.com/toad