Schema limits summary

This document describes the DB2 schema limitations in great detail (there are 27 identifier length limits), and in terms that I find a little misleading (e.g. Longest unqualified column name, which does not mean column name).

To avoid confusion, some of the more important limits are summarized here:

Description Limit in Bytes Example
Longest column alias 30 select foo as XXX from …
Longest column name 30
Longest trigger name 18
Longest index name 18
Longest table name 128
Longest stored procedure name 128

It's only fair to share...
Share on FacebookGoogle+Tweet about this on TwitterShare on LinkedIn

Leave a Reply