473,842 Members | 1,917 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to find the primary key of a particular table?

7 New Member
hi,

i am working on db2.
how can i check for a particular table,the primary key of that table.
for eg. in table REGISTRATION their are around 20 columns. how to check which is the primary key of that table
Feb 1 '11 #1
2 19972
deepak n
3 New Member
Try the following query

SELECT sc.name
FROM SYSIBM.SYSCOLUM NS SC
WHERE SC.TBNAME = 'REGISTRATION'
AND sc.identity ='N'
AND sc.tbcreator=sc hemaname
AND sc.keyseq=1
Feb 1 '11 #2
Aniket sonmale
7 New Member
It worked.

Thank you deepak
Feb 1 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

10
2052
by: mike | last post by:
regards: Where to find tag mapping-table of HTML translated to XHTML1.0 Any positive suggestion is welcome. thank you May goodness be with you all
0
1374
by: Justin Tocci | last post by:
I've found the pg_depend table, but it doesn't appear to include this info. (Or am I missing it?) I'm looking to get all view names that I need to drop to allow a particular table to DROP RESTRICT. Alternately, I would be happy with a way to get the names of objects that are dropped when DROP CASCADE is used.
1
2362
by: JJ | last post by:
Hi, Ok using Typed Datasets and using a table in that dataset that I am working on. What do I use in order to find a particular row and be able to update db with row changes? Do I use a dataview thats tied to datatable and have it find it that way or is their something else in order to find a particular row?
3
9376
by: bikkaran | last post by:
how to find the base table of an ALIAS ? thanks
26
138079
rsrinivasan
by: rsrinivasan | last post by:
Hi, 1. I have some table. But i do not know how to find primary key column, forign key column in that table. Is any procedure or function is available in oracle to find this?. Thanks, Srinivasan r
1
1383
by: sandeep banerjee | last post by:
suppose i have got a project which uses 100 forms .there is a particular table say t_1 which is used in many forms .I want to make change in the code where ever the table t_1 is used.through form builder i can check the individual form..Is there any way to check in the complete project at one go..???
1
3863
by: judy | last post by:
I have several databases that are used to collect data for different client-projects. My intention was to collect the data, and administer mySQL so each client could see only their data. Each of these databases used to collect data have the same tables. There are other databases which are available to all the users which contain common information. The command "show databases" lists all of the databases (visible to the particular...
6
3678
by: warpcon | last post by:
Im trying to build a database starting with one of the templates that come with access. I took out the employee part in all the tables and forms. Now when I pull up a workorder and then try to view the report on it it gives me the message " Ms jet database engine cannot find the input table or query ' Employees'. Make sure it exists and that its name is spelled correctly. I deleted the employee parts on purpose because I didnt need it. Where...
1
2204
by: alex250374 | last post by:
Hello to all, are not practical and db2... I need urgent help: how can count the number of select is done on a particular table in a certain period of time?
0
9870
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9715
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10670
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10308
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9451
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7854
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7030
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4499
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3141
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.