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

What is coalesce in db2?

1143


Is db2 a database?

984


Mention data types used in db2 ?

1166


What is the purpose of rollback and commit?

1203


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1113


Give the name of some fields form sqlca.

1092


What do you mean by rollback?

993


What is iseries database?

1057


How can you find out the # of rows updated after an update statement?

1116


What are the different types of base tables?

1102


What is the use of predicate?

1049


How does coalesce work?

1033


What is ibm db2 database?

1016


Explain about open switch business continuity software?

1140


What type of database is db2?

975