p4 dbschema
Report information about metadata in the database on the Helix Server.
Syntax
p4 [g-opts] dbschema [tablename[:tableversion]]... p4 [g-opts] dbschema [-A] [tablename]...
Description
The p4 dbschema command is intended for systems integrators. This command provides tagged output about
the database structure in which the
Helix Core Server stores metadata.
- To get the current version of all tables, use p4 dbschema
- To get all versions of all tables, use p4 dbschema -A
- To get the current version of a
specific table, use p4 dbschema tablename, where the tablename is the name of the corresponding
db.file in the Helix Server root directory. Table names are the file names that start with db., such as db.archmap, db.user, and so on.tablename - To get all versions of particular table, use p4 dbschema -A tablename
- To restrict output to a specified version of a specified table, use the tablename[:tableversion] syntax, such as db.rev:8
See the Examples that follow as well as the Helix Server Schema Documentation.
Options
|
|
Restrict output to the specified table name. |
|
|
Restrict output to the specified table version. |
| -A | Display information about all versions. |
|
|
See Global options. |
Usage Notes
| Can File Arguments Use Revision Specifier? | Can File Arguments Use Revision Range? | Minimal Access Level Required |
|---|---|---|
|
N/A |
N/A |
available to a service user |
Examples
| Command | Display information about ... |
|---|---|
| p4 dbschema |
the current version of all database tables. |
| p4 dbschema -A |
all versions of all database tables. |
| p4 dbschema db.rev |
the current version of the specified table. |
| p4 dbschema -A db.rev |
all versions of the specified table. |
| p4 dbschema db.user db.rev:8 |
the current version of the |
