Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data Dictionary experts....please suggest!!!!!!

Former Member
0 Likes
400

I have a basic question regarding key in database tables.

Can we make a field as a key field and still have the value NULL for that field in the table??

Are key fields are not primary keys?? )

Please clarify.

Thanks,

Naren

1 ACCEPTED SOLUTION
Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
332

Yes, you can have a "null" value in a key field of a table. The key fields in a table are usually referred to as the primary key.

Regards,

Rich Heilman

I have a basic question regarding key in database tables.

Can we make a field as a key field and still have the value NULL for that field in the table??

Are key fields are not primary keys?? )

Please clarify.

Thanks,

Naren

1 REPLY 1
Read only

RichHeilman
Developer Advocate
Developer Advocate
0 Likes
333

Yes, you can have a "null" value in a key field of a table. The key fields in a table are usually referred to as the primary key.

Regards,

Rich Heilman