• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Is there a maximum key length for a JDE Database table?

jimjung27

Active Member
Running on E900 Tools Release 8.98.42. This company is using MS-SQL Server 2008 R2 on Windows 7 Pro SP1 64 bit.

I am wondering if there is a maximum size to a key field defined in E1 in Table Design Aid (TBA).
I know that there is a maximum in SQL Server of 900 bytes for the total key length.
 

vgsharma

Member
Hi Jimjung,

Table property limits have been stored in the F9300 (Database Property Values) table.
You can find Maximum key length for E1 Table in to F9300.

Also you can reffer My Oracle Support Doc 1077277.1.
 
Top