SQL Server Table Name Limitations

Table Name in SQL Server can be a maximum of 128 characters (except local temporary table names that cannot exceed 116 characters) and must follow identifier rules undermentioned:

·         The first character must be one of the following

o   Character from a-z or A-Z

o   Underscore (_), at sign (@), or number sign (#)

    If a table name starts with number sign (#) then this table will be created as temporary table in TempDB and will be access only through current connection.

    If a table name starts with double number sign (##) then this table will be created as global temporary table in TempDB and will be access only through current connection.

·         Subsequent characters can include the following:

o   Character a-z or A-Z

o   Digit 0-9

o   Underscore (_), at sign (@), number sign (#) or dollar sign ($)

·         The identifier must not be a T-SQL reserved word.

·         Special characters are not allowed.