• admin
• June 21, 2024
• No Comments

Here are some maximum number of different objects in sql server.

1. maximum number of character in table name-128
2. maximum number of character in column name-128
3. maximum number of table columns per select statement -4096
4. maximum number of table columns per table-1024
5. maximum number of foreign key reference per table-253
6. maximum number of column per index-16
7. maximum number parameters in stored procedure -1024
8. maximum number of columns in view-128