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 Facebook
Tweet about this on Twitter
Share on LinkedIn

Leave a Reply