Number of columns per table and per index

Maximum number of columns (attributes) per table / Maximum number of columns (attributes) per table in Oracle, IBM DB2, MySQL, SQL Server etc. / Maximum number of attributes that can be created per table in various RDBMSs

Maximum number of columns / attributes per table, index, primary key and foreign key



RDBMSs
Columns
Maximum number of columns per
Table
Primary key
Index
Foreign key
IBM
-          DB2 for Linux and Windows 11.1
-           
1012

64
64
MS Access
-          MS Access 2010
255
10
10

MySQL
-          MySQL 5.7 (InnoDB tables)
1017

16

Oracle
-          Oracle 11g
1000
32
32
32
PostgreSQL
-          PostgreSQL 9.6
250 – 1600 (depending on column types)

321

SQL Server
-          SQL Server 2016
30000 (wide table)2
1024 (non-wide table)
16
32
16


References:


Go back to Advanced DBMS Concepts page




No comments:

Post a Comment

Popular Posts