4,707 questions
This is a MS SQL Server forum, not Sybase. Although they are closely related, you would be better off using a Sybase forum.
list of primary keys - Sybase DB.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 74%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dhar
96
Reputation points
Hello friends
.
I need the list of the primary keys for each table in a database . if a table has 1 key or 2 primary keys . it should show me in result set.
.
Please help me with the query . i am using the below "sp_pkeys". it is giving me correct and required result set .
exec sp_pkeys 'tableName'
but i need a Query .
My database is Sybase 15
Developer technologies | Transact-SQL
SQL Server | Other
14,494 questions
{count} votes
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2021-11-11T02:30:34.99+00:00 Hi @Rakesh Dhar ,
We have not received a response from you. Did the reply(s) could help you?
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,771 Reputation points2021-11-09T18:51:13.53+00:00 -
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2021-11-09T22:40:40.143+00:00 These days I would not call them "closely" related. And, particularly, Microsoft has completely redesigned how metadata is stored, so queries for SQL Server will not run on Sybase.
What you can do is:
EXEC sp_helptext sp_pkeysto look at the code, and use that to craft your query.
Sign in to comment -
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2021-11-10T02:24:49.143+00:00 Hi @Rakesh Dhar ,
Welcome to MS Q&A forum.
Your issue is related to Sybase DB. SQL server general and sql-server-transact-sql tags are talking about MS SQL server tech issues. Suggest you to create a new thread on Sybase DB forum. People there will give you a better help.
https://stackoverflow.com/questions/tagged/sybase
By the way, this a similar thread, please check if the solution from this thread could help you.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.