Appendix: VMart Example Database Schema, Tables, and Scripts

The Appendix provides detailed information about the VMart example database’s schema, tables, and scripts.

The VMart example database contains three different schemas:

The term “schema” has several related meanings in Vertica:

Each schema contains tables that are created and loaded during database installation. See the schema maps for a list of tables and their contents:

The VMart database installs with sample scripts that contain SQL commands that represent queries that might be used in a real business. The sample scripts are available in the Sample Scripts section of this Appendix. Once you’re comfortable running the example queries, you might want to write your own.