The ‘%’ matches zero or more characters in the trigger name.The table names in the list can include the ‘%’ and underscore ‘ _ ’ characters, which provide pattern-matching semantics: -T trigger_name - A comma-separated list of triggers for which definitions should be generated.Use the optional user_name qualifier to specify a procedure owned by a different user. The underscore ‘ _ ’ matches a single character in the procedure nameīy default, dbschema generates definitions for procedures owned by the current user.The ‘%’ matches zero or more characters in the procedure name.The table names in the list can include the ‘%’ and underscore, ‘ _ ’, characters, which provide pattern-matching semantics: -p procedure_name - A comma-separated list of stored procedures for which definitions should be generated.Use the optional user_name qualifier to specify a table owned by a different user. This differs from the behavior of the % in the -p and -T options.īy default, dbschema generates definitions for tables owned by the current user. It substitutes for the entire table_name argument and cannot be used for pattern matching within in a character string. Note: With the -t option, the % character is not a true wildcard character. Specify a list of specific tables, or use the % to generate definitions for all tables. -t table_name - A comma-separated list of tables and views for which definitions should be generated.
-o outfile - Redirects the output to the specified file.-S BASIC | - Basic TLS encryption or cross checked authentication using.(On UNIX, the value of the DH_PASSWD environment variable specifies the default password.) If omitted, the default value depends on the environment. c-treeSQL verifies the password against a corresponding user name before it connects to the database. -a password - The password c-treeSQL uses to connect to the database.If DH_USER is not set, the value of the USER environment variable specifies the default user name.) (On UNIX, the value of the DH_USER environment variable specifies the default user name. c-treeSQL verifies the user name against a corresponding password before it connects to the database. -u user_name - The user name c-treeSQL uses to connect to the database.The output of the dbschema command invoked with the -d option can be directed to a command file and executed in interactive c-treeSQL to duplicate and load table definitions. -d - In conjunction with the -t option, specifies that dbschema generates c-treeSQL INSERT statements for data in the tables, in addition to CREATE statements.-h - Displays brief online help of dbschema syntax and options.If the dbschema statement omits all arguments, it displays definitions for all elements (tables, views, indexes, procedures, and triggers) for the default database on the screen. Generates c-treeSQL statements to recreate the specified database elements and data.
The FairCom DB SQL utility, dbschema, recreates specified database elements and data.ĭbschema The dbschema utility generates FairCom DB SQL statements to recreate the specified database elements and data.
0 kommentar(er)
