venkat

• Mar 19th, 2006

 

maximum number of columns in a table is 254

meetnaveen4u

 Profile Answers by meetnaveen4u 

• Mar 24th, 2006

 

Table or view can have upto 1000 columns.

Aditya

• May 16th, 2006

 

A table can have max of 255 columns

Adarsh S Pazhayampillil

• Aug 7th, 2006

 

250 - 1600 depending on column types

khaja

• Aug 7th, 2006

 

It varies from 250 to 1600 depends on column types

Lalit Kumar

• Oct 25th, 2006

 

The maximum number of columns in a table or view are 1000.

Nikhil_4_Oracle

• Mar 15th, 2007

 

Final Answer : 1000 columns/table.

laxma823

 Profile Answers by laxma823 

• Aug 6th, 2008

 

A table contains maximum 1000 columns

emraan

 Profile Answers by emraan 

• Dec 27th, 2009

 

The maximum number of columns in a table or view is 1000

sirih1

 Profile Answers by sirih1 

• May 24th, 2011

 

ORA-01792: maximum number of columns in a table or view is 1000
Cause: An attempt was made to create a table or view with more than 1000 columns, or to add more columns to a table or view which pushes it over the maximum allowable limit of 1000. Note that unused columns in the table are counted toward the 1000 column limit.

Action: If the error is a result of a CREATE command, then reduce the number of columns in the command and resubmit. If the error is a result of an ALTER TABLE command, then there are two options: 1) If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns; 2) Reduce the number of columns in the command and resubmit.

ambinu

 Profile Answers by ambinu 

• Jun 14th, 2011

 

MySQL: Maximum number of columns in one table - 3398; size of a table row - 65534 (BLOB and TEXT not included). Oracle: Unlimited rows@table. Maximum number of columns in one table - 1000. Up to 32 columns in index key. PostgreSQL: Rows - unlimited, columns - 1600; size of a table row - 1.6TB.

venkat

• Dec 4th, 2011

 

From Oracle 9i it allows maximum 1000 columns in a table. In Oracle 8i, it only allows 256 columns in a table.