Declare option field as primary key.

Rajat_M · 2016-04-13

Hello,

Can I declare an option field as a primary key in a table?? If so then can I modify this field by using RENAME() function??

Thank You,

postsaurav · 2016-04-13

Hi,
Look for Table 36 Sales Header or any of the document header table.
Can you rename a Sales Document?

RockWithNAV · 2016-04-13

Hey Rajat,

Always have a look on some standard tables whenever you stuck on some questions like this. You might have seen Sales Header and Purchase Header Tables. There you would have seen Document Type as a part of Primary key and which is a Option type field, so here you have the answer of your first question. For your second question please have a look on this, you will understand.

https://msdn.microsoft.com/en-us/library/dd355414.aspx

https://msdn.microsoft.com/en-us/library/dd355313.aspx

mohana_cse06 · 2016-04-13

yes and yes

postsaurav · 2016-04-13

Hi,
Look for Table 36 Sales Header or any of the document header table.
Can you rename a Sales Document?

RockWithNAV · 2016-04-13

Hey Rajat,

Always have a look on some standard tables whenever you stuck on some questions like this. You might have seen Sales Header and Purchase Header Tables. There you would have seen Document Type as a part of Primary key and which is a Option type field, so here you have the answer of your first question. For your second question please have a look on this, you will understand.

https://msdn.microsoft.com/en-us/library/dd355414.aspx

https://msdn.microsoft.com/en-us/library/dd355313.aspx

mohana_cse06 · 2016-04-13

yes and yes

Declare option field as primary key.

Best Answers

Answers

Categories