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:

1. PostgreSQL - columns per index

2. SQL server - Wide or non-wide tables

Go to maximum number of indexes per table (clustered and non-clustered)

Go back to Advanced DBMS Concepts page