0
I am learning SQL, and ran into the following problem:
I need to know which of the columns is the primary key of the table. Have some command I can use in SELECT to get as return that information?
I’ve seen the topic:
How to mount a select that brings information of which column is PK, which is not, and which is FK
Didn’t help at all.
Which DBMS is using?
– gato
Hello. It’s the H2 Database Engine.
– Lucas Pletsch
At a glance link, I think it might help.
– gato
Worst I didn’t find anything on this link either. You know how this is done on some other DBMS?
– Lucas Pletsch
Read the correct Metadata table (Metadata) of the BD in question.
– Motta