SQL Server Maximum Character Length- Table and Field Names

[MSingh]

Hi,

I'm seeking confirmation on the following 2 points (I trust the advices from Eileen's Lounge over google searches):

1. The maximum number of characters in a table name in SQL Server is 128.

2. The maximum number of characters in a field name in SQL Server is 128.

Would these limitations apply to all versions of SQL Server from 2008 onwards ie. SQL Server 2008 Express + ?

Your advices are appreciated.

Kind Regards,
Mohamed

[HansV]

According to Microsoft, the following applies to all versions of SQL Server from SQLServer 2008 through the current version (SQL Server 2014):

table_name can be a maximum of 128 characters

Source: CREATE TABLE (SQL Server)

column_name can be a maximum of 128 characters

Source: ALTER TABLE (Transact-SQL)

[MSingh]

Thank You Hans.
Kind Regards,
Mohamed