Total Answers and Comments: Last Update: February 12, 2008 Asked by: Rado mathan Kumar
Submitted by : dhanaMaximum No of columns n a table is 1024
maximum foreign keys is 253
Above answer was rated as good by the following members: Rsubscribe
Sorting Options
Latest First
Oldest First
By Rating
May 25, 2006 06:57:25 #5
sasi
RE: how many column maximum we can add in one table a... Maximum no of columns in a table is 1000
and foreign key id 32
Regards
Sasi
Is this answer useful? Yes No
May 30, 2006 17:58:27 #6
Yoseph Kassaye
RE: how many column maximum we can add in one table a... 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.
Is this answer useful? Yes No
September 19, 2006 08:16:39 #9
Ritesh P. Medhe
RE: how many column maximum we can add in one table a... I agree 100 with dhana
Maximum No of columns n a table is 1024
maximum foreign keys is 253
Is this answer useful? Yes No
Go To Top
0 
1