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
Printable View
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.
[URL="http://msdn.microsoft.com/en-us/library/ms143432.aspx"]Maximum Capacity Speicification for SQL Server 2005[/URL]
---V V---
Vikas Vaidya
[I]Please mark this post as Thanks if u found it useful[/I]
[QUOTE=mohsink4u;32911]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[/QUOTE]
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