The create table command builds the new table in the currently open database. 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..”. For more information, see “Using temporary tables”.
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 hold for 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. Limits for the length of object names or identifiers: 255 bytes for regular identifiers, and 253 bytes for delimited identifiers.
For variables, “@” count as 1 byte, and the allowed name for it is 254 bytes long.
