>>>How do I find out the name of the primary key in a table and its default value? Thanks
>>>
>>>
>>>
>>>Nick patel
>>
>>Check PRIMARY() function in HELP.
>>What do you mean with DEFAULT value?
>>Index gas no such value :-) maybe you want the default value of the fields which is used as a KEY for that index?
>
>
>thanks for answering back Borislav, The default value I want see is under field validation. When we modify the structure, you can see there is a spot called "Default Validation" right under the "Message:" in the field validation section. Thanks
>
>Nick
That has nothing to do with index. That is field property :-)
OPEN DATABASE YourDataBase
USE YourTable
WAIT WINDOW DBGETPROP([FieldNameHere],[FIELD],[DefaultValue])
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.