Table Names

Table names must be unique for each user.

You can create temporary tables either by preceding the table name in a create table statement with a pound sign (#), or by specifying the name prefix “tempdb”.

You can use any tables or other objects that you have created without qualifying their names. You can also use objects created by the database owner without qualifying their names, as long as you have the appropriate permissions on them. These rules apply to all users, including the system administrator and the database owner.

Different users can create tables of the same name. For example, a user named “jonah” and a user named “sally” can each create a table named info. Users who have permissions on both tables must qualify them as jonah.info and sally.info. Sally must qualify references to Jonah’s table as jonah.info, but she can refer to her own table simply as info.

Related concepts
Temporary Tables Usage