+ 5

Little help with SQL

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?

15th Mar 2022, 3:04 PM
Rishi
Rishi - avatar
4 odpowiedzi
+ 4
Simon Sauter wow awesome! I tried for a long time and didn't get it. thank you very much :)
15th Mar 2022, 4:26 PM
Rishi
Rishi - avatar
+ 3
SoloProg thank you but I'm using an Android device to do all these😅
16th Mar 2022, 12:31 AM
Rishi
Rishi - avatar
+ 2
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
15th Mar 2022, 10:26 PM
SoloProg
SoloProg - avatar