SqlServer schema table erroneous ?

[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 ?

 

[IbrahimMalluf]

Try sp_pKeys: "Exec sp_pKeys @table_name='yourtablename'"



--
Ibrahim Malluf
http://www.malluf.com
==============================================
MCS Data Services Code Generator
http://64.78.34.175/mcsnet/DSCG/Announcement.aspx
==============================================

 

[Lloyd Dupont]

ouh....
great !!!

thanks ;-) !

Try sp_pKeys: "Exec sp_pKeys @table_name='yourtablename'"



--
Ibrahim Malluf
http://www.malluf.com
==============================================
MCS Data Services Code Generator
http://64.78.34.175/mcsnet/DSCG/Announcement.aspx
==============================================

 

[Lloyd Dupont]

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 ...

 

[Lloyd Dupont]

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 ?

 

[Lloyd Dupont]

don't worry.
I skim SqlServer documentation and made a great leap forward ;-)