Re: Does included columns part of the PK

Adrian,,

On Mon, Mar 16, 2026 at 5:44 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 3/16/26 4:38 PM, Igor Korot wrote:
> > Adrian,
> >
> > Most important - do you agree that those fields should not be in this
> > recordset?
>
> I don't see anything here:
>
> https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlprimarykeys-function?view=sql-server-ver17
>
> that says they should be returned. Though the above also says:
>
> " Additional columns beyond column 6 (PK_NAME) can be defined by the
> driver."
>
> That is not the case here, where additional rows are used. However it
> does allow for more information to be supplied.
>
> My purely un-expert analysis is, no the extra rows should not be there.

Thx for confirming.

I already forwarded the email with the query results over to ODBC list.

Hopefully someone can come back soon.

Are you reading that list as well? If not I will update this thread
with the results.

Thank you.

>
> >
> > Thank you.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com