SqlServer schema table erroneous ?

  • Thread starter Thread starter Lloyd Dupont
  • Start date Start date
L

Lloyd Dupont

I have a very basic test SqlServer table:

Key ID Name DataType
X id_0 int
X id_1 int
id_3 char

I use the DataReader's method: GetSchemaTable() to get this information from
the database in my .NET program (on the PPC, I use the compact framework)

the column "IsIdentity" seems to be correctly filled.
whereas the column "IsKey" seems to be not

in fact I run the method in the debugger, querying manually all the column,
I have no particular info on the "id_0" column, absolutely no way to know
it's a primary key column !....

is it a bug of SqlServer in general ? or on the Compact frameqork in
particular ?
is there an other way to know a column is a primary key ?
 
nice web site by the way ;-)

save the big titles which are written over the body of text and the complete
abscence of geographical location ...
 
it works but it looks too much like Magic !
I see ne sp_pKeys in the stored procedure list.
would you care enlighten me a bit more about what this statement means ?
 
Back
Top