Create Tables in Different Databases

You can create a table in a database other than the current one by qualifying the table name with the name of the other database.

However, you must be an authorized user of the database in which you are creating the table, and you must have create table permission in it.

If you are using pubs2 or pubs3 and there is another database called newpubs, you can create a table called newtab in newpubs like this:

create table newpubs..newtab (col1 int)

You cannot create other database objects—views, rules, defaults, stored procedures, and triggers—in a database other than the current one.