In SQL Server 6.5, you are allowed 250 columns per table. This limit has gone up to 1024 in SQL Server 7. As for Oracle or any other backend, somebody will need to chime in with those statistics.


>Hello all,
>
>We would like to move our FoxPro tables to SQL database. One criterion is very important to us: we do not want to have a limit of 255 columns per table. What SQL database does not have this limit?
>
>Thank you.