I'm new to SQL Server 7. Is there a limit to the number of fields that a table can have?
Printable View
I'm new to SQL Server 7. Is there a limit to the number of fields that a table can have?
Yes - fully documented in BOL
Max 1024 columns per table with total row length not exceeding 8060 bytes.
Mike John
KnowledgePool ltd
------------
clueless at 3/6/00 6:37:40 PM
I'm new to SQL Server 7. Is there a limit to the number of fields that a table can have?