Chandra Bosh Kumar

• May 8th, 2006

 

Maximum coloumn in a table as 255 fiels indivisually.

P.Rathi

 Profile 

• May 17th, 2006

 

maximum foreign key in one table :-  253

Hari Haran Arulmozhi

• May 22nd, 2006

 

Maximum Columns in a base table : 1024

Maximum Foreign Keys in a table : 16

P.Rathi

 Profile 

• May 23rd, 2006

 

Foreign key table references per table- 253

Columns per foreign key -16

sasi

• May 25th, 2006

 

Maximum no of columns in a table is 1000

and foreign key id 32

Regards,

Sasi

Yoseph Kassaye

• May 30th, 2006

 

The column length is dependent up on the type of statement we are using:

It will be 4,096 for select statement 1024 for insert statement.

The number of foreighn key maximum we can use in a table is 16 and we can link with 253 tables.

dhana

• Jun 6th, 2006

 

Maximum No of columns n a table is 1024

maximum foreign keys is 253

Biju Joseph

• Jul 8th, 2006

 

Description	4K page size limit	8K page size limit	16K page size limit	32K page size limit
Most columns in a table	500	1 012	1 012	1 012

Ritesh P. Medhe

• Sep 19th, 2006

 

I agree 100% with dhana

Maximum No of columns n a table is 1024

maximum foreign keys is 253

dharanidhar

• Feb 10th, 2007

 

please specify your oracle varsion numbers .is it 255 or 1053 i think for oracle 9i 255and oracle 10g 1000 tables make sure when you discuss this type of questions specify verion numbers. ook

bnsp4u

 Profile Answers by bnsp4u 

• Aug 31st, 2007

 

A maximum of 1024 colomns can be created in a table and max of 253 f.ks

sham

• Sep 13th, 2007

 

Columns per base table: 1,024
Columns per foreign key: 16
Foreign key table references per table: 253

sreyas kvm

 Profile Answers by sreyas kvm Questions by sreyas kvm

• Feb 3rd, 2008

 

Columns:1000Foreidn key:32

venkat.rbs

 Profile Answers by venkat.rbs 

• Feb 12th, 2008

 

we can define up to 1024 columns. in one table....

And 253 forignkeys we can assign for 1 table...