Accessing tables in other database which are created in master database.

If you want to see tables created in master database to your user database, create the table with name  "sp_"  as prefix .

You can access the table in any user database.

First create table:

USE
CREATE TABLE sp_test (id int)
 
USE master
INSERT INTO sp_test VALUES(1)
INSERT INTO sp_test VALUES(2)
INSERT INTO sp_test VALUES(3)
INSERT INTO sp_test VALUES(4)
INSERT INTO sp_test VALUES(5)

Now select from other user database

USE test
SELECT  * FROM sp_test

you will get following.

id
1
2
3
4
5  master