Introduction
This blog explains about the maximum length of objects in SQL Server. Each object has maximum size limitations.
Column Name
SQL maximum column name length limitation is 128 characters. If we create more than 128 characters, it shows an error. The total number of columns limitation is 1024. We cannot create more than 1024 columns in SQL server.
Database Password
The maximum length of database password characters is 40.
Table Name
The table name is very important in SQL server. The maximum length of table name characters is 128.
Table Size
There is no limitation for creating tables in SQL server. We can create an unlimited number of tables in SQL server.