Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to know the primary key of a table without defining the
primary key in the table?

Answer Posted / ambika

u can use sysibm.syskeys to view the primary key of a
particular table provided if u have declared any attribute
as NOT NULL. if there are multiple columns of such kind u
the above procedure wont help.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I delete a column in db2?

1049


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1018


How do I add a column to an existing table in db2?

977


What is a page in db2?

980


What is collection in db2 bind?

961


What is the result of open cursor statement?

1028


How to find primary key of a table in db2?

1002


Can there be more than one cursor open for any program?

1123


How do you find the maximum value in a column in db2?

1053


Are view updateable?

980


What is a db2 cursor?

1005


What are packages in db2?

972


What is image copy in db2?

944


What is syscat in db2?

950


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114