What is the max columns per table?
You are limited by the 4K page size so you could have 4088 columns and 119 key segments in a table, but that would limit your column size to 1byte. You could have over 511 8 byte columns in a table. 32K total record length counting the variable length field on the SQL side (SQL Server 7 has an 8K record limit by contrast and SQL server 6.5 had a 2K record limit – limited by page size).
Related Questions
- Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
- Can I apply CMP entity beans for very long (several million bytes) table columns? Are response times still acceptable?
- Can I fix the ONfinity CM2 Max onto the ceiling or just put it on the table?
