Thread: Columns in a table

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

Originally Posted by mohsink4u

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

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