November 10, 2004 at 9:03 am
Can anyone please let me know the max number of columns that we can have on a sql server table. Any help will be greatly appreciated.
TIA
November 10, 2004 at 9:06 am
Thanks,I got it from BOL.
SQL Server can have as many as two billion tables per database and 1,024 columns per table. The number of rows and total size of the table are limited only by the available storage. The maximum number of bytes per row is 8,060.
November 10, 2004 at 11:59 am
Good man! BOL is your best first source for information. I use it every day.
Wes
November 11, 2004 at 3:03 am
The maximum number of bytes per row is 8,060.
will be less if you use replication !!
GKramer
The Netherlands
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply