When you use federations in SQL Azure do you have to have the tenantid as part of the primary key on every table? That would mean that all tables except maybe one tenant table would all have composite primary keys (one that is really the primary key and then adding in the tenantid).
That appears to be what it says in this article.
