Advanced Database Management System - Tutorials and Notes: Number of columns per table and per index

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Sunday, 27 November 2016

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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents