sun.com | docs.sun.com |  | How To Buy | My Sun | Worldwide Sites |

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Application Server Utility | capture-schema(1M)

- NAME
- SYNOPSIS
- DESCRIPTION
- OPTIONS
- EXAMPLES
- SEE ALSO

## NAME

| capture-schema - stores the database metadata (schema) in a file for use in mapping and execution

## SYNOPSIS

| `capture-schema -dburl url``-username name -password password -driver a_jdbc_driver` [-schemaname name] [-table tablename] `*` [-out filename]

## DESCRIPTION

| Use the `capture-schema` command to store the database metadata (schema) in a file. You can also use the Sun ONE Studio (formerly Forte for Java) IDE to capture the database schema.

## OPTIONS

| -dburl JDBC URL expected by the driver for accessing a database. -username user name for authenticating access to a database. -password password for accessing the selected database. -driver JDBC driver classname in your CLASSPATH. -schemaname name of the user schema being captured. If not specified, the default will capture metadata for all tables from all the schemas accessible to this user. Specifying this parameter is highly recommended. If more than one schema is accessible to this user, more than one table with the same name may be captured which will cause problems. -table name of the table; multiple table names can be specified. -out output target; defaults to `stdout`. This parameter corresponds to the `schema` sub-element of the `sun-cmp-mapping` element in the `sun-cmp-mapping_1_0.dtd` file.

## EXAMPLES

| Example 1. Using capture-schema
    capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
    -schemaname cantiflas -username cantiflas -password enigma -driver
    oracle.jdbc.driver.OracleDriver

## SEE ALSO

| `asadmin`(1M)

| Go To Top | Last Changed April 2004

Company Info | Contact | Copyright 2003 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms.