Column limit

9 Sep 2005 8:10 PM

KenH

Is there a limit on the number of columns you can create in SQL Server?
I keep hearing 250 but I can't find anything definate.

Ken

9 Sep 2005 8:18 PM

Trey Walpole

BOL: Maximum Capacity Specifications

Columns per base table: 1024

KenH wrote:
Show quote

> Is there a limit on the number of columns you can create in SQL Server?
> I keep hearing 250 but I can't find anything definate.
>
> Ken
>

9 Sep 2005 8:24 PM

Hugo Kornelis

On 9 Sep 2005 13:10:51 -0700, KenH wrote:

>Is there a limit on the number of columns you can create in SQL Server?
>I keep hearing 250 but I can't find anything definate.
>
>Ken

Hi Ken,

Did you check Books Online? In the index, "Maximum number of columns per
table" points to the description of CREATE TABLE, where (under the
heading "Remarks") it says:

>>SQL Server can have as many as two billion tables per database and 1,024 columns per table.
(...)
>>The maximum number of bytes per row is 8,060.

And the index entry "maximum capacity specifications" takes you to a
table that lists the same number, plus much more information.

Best, Hugo

--

(Remove _NO_ and _SPAM_ to get my e-mail address)

9 Sep 2005 8:43 PM

KenH

Thanks guys!

I'll start using the books online.

Ken