primary key field
-
Hi All, I am using VC++ 2003 and Oracle 10. I have created a table in Oracle. The table has ten fields including a primary key (field). Is there any function in VC++ to know the extracted field (from database) is primary key? I am using ODBC..
-
How would that work?
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
-
How would that work?
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
-
I have not used oracle in some years, I just remember there was a command 'DESCRIBE' table **Update** Found some old code! I think he can do this: SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME = "table" AND CONSTRAINT_TYPE = 'P';
Randor wrote:
I have not used oracle in some years, I just remember there was a command 'DESCRIBE' table
True, but I couldn't find where it populated anything regarding a primary key.
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne