Prepare for your Next Interview
This is a discussion on Columns in a table within the ASP.NET forums, part of the Web Development category; 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. ...
|
|||
|
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 |
| Sponsored Links |
|
|||
|
Re: Columns in a table
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 |
|
|||
|
Re: Columns in a table
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 |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Move columns from different tables to one table | ajit99 | SQL | 6 | 05-16-2008 06:38 AM |
| How to add values to other columns | Mohamed_Rafi | Oracle | 10 | 03-26-2008 11:35 PM |
| In my source table I have two columns | Geek_Guest | Data Warehousing | 3 | 03-26-2008 03:20 AM |
| Set columns as not null | jency | SQL | 2 | 12-06-2007 12:12 AM |
| How much constraints can a table with 100 columns have | Geek_Guest | Oracle | 3 | 07-05-2007 07:45 AM |