Foreign Key from tables that exists in two different DBs on the same server
In Sybase, is it possible to create a a foreign key from a table in my ARCHIVE database to a Reference Table in my main Database? You can assum开发者_JAVA技巧e that the databases are both running on the same Sybase Server.
Yes.
See "Using cross-database referential integrity constraints" in http://manuals.sybase.com/
精彩评论