The Vertica Database Forums

Hi,

what are the maximum number of tables that can be created in a schema in vertica?

Thanks,
Raj.

Raj,

The SQL Reference Manual says the number of tables/projections per database are limited by physical RAM, as the catalog must fit in memory. I believe that there is not a limitation on the actual number of tables, even by schema.