| Home |
| Core Tasks |
| Additinal Tasks |
| Java API |
| Download |
| SF Page |
InspectSchema task
Print all table and view names by schemas. If schema attribute is missed then task tries to get information for all available for a given connection schemas.
Java class is org.chur.ant.db.dbstructure.InspectSchemaTask
Parameters
| Attribute name | Description | Required | Default |
| driver | Class name of the jdbc driver | Yes | – |
| url | Database connection url | Yes | – |
| userid | Database user name | Yes | – |
| password | Database password | Yes | – |
| schema | Schema name to inspect | No | – |
| out | Output file for inspection results (defaults to System.out) | No | System.out |
Examples
<taskdef name="InspectSchemaTask" classname="org.chur.ant.db.dbstructure.InspectSchemaTask"/> <InspectSchemaTask driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@tiger:1521:tigerdb" userid="sys" password="change_on_install"/>
Result
===== 'SCOTT' ===== Tables: Views: ===== 'SYS' ===== Tables: AUDIT_ACTIONS DUAL IMPDP_STATS OLAPI_HISTORY ..... Views: ALL_ALL_TABLES ALL_APPLY ALL_APPLY_CONFLICT_COLUMNS ALL_APPLY_DML_HANDLERS ALL_APPLY_ENQUEUE ALL_APPLY_ERROR ALL_APPLY_EXECUTE .....