Maximum Length of Objects in SQL Server

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.

Ebook Download
View all
Learn
View all