Hi all,
I was asked a question:
How many (maximum) no of colmuns can we have in a table.
How many (maximum) no of non-clustered indeces can we have.
How many composite keys do we have in a table
Thanks
Hi all,
I was asked a question:
How many (maximum) no of colmuns can we have in a table.
How many (maximum) no of non-clustered indeces can we have.
How many composite keys do we have in a table
Thanks
Hi Mohsin,
here is the maximum information that u can get.
Maximum Capacity Speicification for SQL Server 2005
---V V---
Vikas Vaidya
Please mark this post as Thanks if u found it useful
Maximum for objects in sql server
Here are some maximum number of different objects in sql server.
maximum number of character in table name-128
maximum number of character in column name-128
maximum number of table columns per select statement -4096
maximum number of table columns per table-1024
maximum number of foreign key reference per table-253
maximum number of column per index-16
maximum number parameters in stored procedure -1024
maximum number of columns in view-128