i'm at the very start of learning about how to code and started from SQL and Python. I have a task: to list all primary keys in data base. How can I do it? Diagram I used
select * from public
But it returns with error
Asked
Active
Viewed 656 times
-1
-
You ca have a look in below link: https://stackoverflow.com/questions/54628931/view-primary-key-in-dbeaver#:~:text=To%20have%20a%20look%20at,columns%20are%20the%20primary%20keys. – Kazi Mohammad Ali Nur Romel Feb 07 '21 at 08:53
-
Do you need to do it programmatically for some databases or just view them for a particular database? – astentx Feb 07 '21 at 09:03
-
Tag your question with the database you are using. dbeave is a GUI tool, not a database. – Gordon Linoff Feb 07 '21 at 13:51
1 Answers
-1
This the query will list all the primary keys for a SQL Server database:
select * from sys.objects where type = 'PK'
-
1Do not post code-only answers, add an explanation to your code. And not all databases have the same system tables, so this is not a cathall solution – astentx Feb 07 '21 at 08:56
-
1To be clear: this will provide a list of the primary key **constraints** in the current SQL Server database. It does **not** provide the name of the columns in those constraints, nor does it list the **values** in those columns – marc_s Feb 07 '21 at 10:00