Oracle 10G 和 Derby 数据库中的列数限制是多少
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2520871/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the limit on number of columns in Oracle 10G and Derby Databases
提问by Fazal
Until recently I thought limit on number of columns in Oracle DB was 255. But turns out the limit is 1000. Can someone confirm this?
直到最近，我认为 Oracle DB 中列数的限制是 255。但结果限制是 1000。有人可以确认这一点吗？
Also I was trying to find if there is any similar limit on number of columns in Derby DB, particularly embedded derby java DB
我还试图找出 Derby DB 中的列数是否有任何类似的限制，尤其是嵌入式 derby java DB
回答by zendar
Here's link to Oracle documentation: Logical Database Limits.
Excerpt:
这是 Oracle 文档的链接：逻辑数据库限制。
摘抄：
Per table 1000 columns maximum
Per index (or clustered index) 32 columns maximum
Per bitmapped index 30 columns maximum
Here's link to Derby documentation: A Derby Database
Excerpt:
以下是 Derby 文档的链接：A Derby 数据库
摘录：
columns per table 1,012
