Is there a limit on the number of fields in a SQL table

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Is there a limit on the number of fields in a SQL table

Message

From

20/10/2004 13:54:13

Gerard O'Carroll
Kernel Software Ltd.
Dublin, Ireland

20/10/2004 09:55:50

Alexandre B-Ferland
Azur Technologies
Montréal, Quebec, Canada

General information

Forum:

ASP.NET

Category:

Other

Title:

Re: Is there a limit on the number of fields in a SQL table

Miscellaneous

Thread ID:

00952948

Message ID:

00953077

Views:

Hi Alexandre.
Thanks for the info.

Gerard

>Hello Gerard,
>
>Look for Maximum Capacity Specifications in Books Online...
>It says that the limit is 1024 fields for a total of 8060 bytes per row...
>
>I think 400 fields is a lot for a table... maybe you should review your data
>model design. I can't imagine the INSERT/UPDATE stored procedures for this table :)
>
>Best regards,
> Alex

Map

View

Click here to load this message in the networking platform