PRIMARY KEY problems

[Morpheus1981]

I am using this query ("SELECT * FROM INFORMATION_SCHEMA.constraint_column_usage&quot
with my personal DataBase "demo01", for some reason it doesn't bring primary key fields for tables which its owner is not dbo, which is very necesary.

Does anyone know why? or what can I do to make my tables with a different owner be shown by this query?

Thanks,

 

[ks2000]

you can try like this
select * from <ownere Name>.<tableName>

 

[billchris]

The view that you are selecting from, INFORMATION_SCHEMA.constraint_column_usage, only displays records from tables for which the current user has permissions. Check to make sure the user that you are connecting with has permission to use/see the tables in question.



“I apologize for this long letter. I didn't have the time to make it any shorter” --Blaise Pascal