Maximum Length

Question

User429228380 posted

Maximum Length of Table Name in SQL Server?

Answer 1

User-1672470423 posted

128. Go through below article specifying how to figure it out.

http://blog.sqlauthority.com/2014/03/07/sql-server-retrieve-maximum-length-of-object-name-with-sp_server_info/

Answer 2

User1751268424 posted

128 chars, reff: https://technet.microsoft.com/en-us/library/ms172451(v=sql.110).aspx

Have fun

Answer 3

User77042963 posted

The datatype of the column to hold your table name is sysname, which is nvarchar(128).

Answer 4

User364663285 posted

128 characters. This is the max length of the sysname datatype (nvarchar(128)).

Answer 5

User-1636183269 posted

All table name can have minimum 1 to maximum of 128 characters in their names in SQL Server. Except few exception is local, temporary tables that can have a maximum of 116 characters.

http://blog.sqlauthority.com/2012/05/01/sql-server-maximum-allowable-length-of-characters-for-temp-objects-is-116-guest-post-by-balmukund-lakhani/