top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How many columns can table have in Oracle?

+3 votes
How many columns can table have in Oracle?
posted Oct 21, 2014 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

3 Answers

+1 vote
Best answer

one table can have maximum 1000 columns.

answer Jul 10, 2015 by Gskumar
Yes you are right, for 8i, 9i, 10g, and 11g, the limit is 1,000 columns per table. Prior to that, Oracle 7 had a 254 column limit.
+1 vote

The number of columns in a table can range from 1 to 254.

answer Oct 22, 2014 by Arun Gowda
0 votes

SQL Server Maximum Columns Limit

Bytes per short string column 8,000

Bytes per GROUP BY, ORDER BY 8,060

Bytes per row 8,060

Columns per index key 16

Columns per foreign key 16

Columns per primary key 16

Columns per nonwide table 1,024

Columns per wide table 30,000

Columns per SELECT statement 4,096

Columns per INSERT statement 4096

Columns per UPDATE statement (Wide Tables) 4096

When you combine varchar, nvarchar, varbinary, sql_variant, or CLR user-defined type columns that exceed 8,060 bytes per row

answer Nov 14, 2014 by Manikandan J