ddlutils怎么获取oracle查看所有schema的schema

来源：蜘蛛抓取(WebSpider) 时间：2017-07-25 01:33 标签： mysql 查看所有schema
Welcome to DdlUtils
Search...The DdlUtils siteThe web for
What is DdlUtils
DdlUtils is a small, easy-to-use component for working with Database Definition
(DDL) files. These are XML files that contain the definition of a database schema, e.g. tables
and columns. These files can be fed into DdlUtils via its Ant task or programmatically in order to
create the corresponding database or alter it so that it corresponds to the DDL. Likewise, DdlUtils
can generate a DDL file for an existing database.
DdlUtils uses the Turbine XML format, which is shared by
and . This format expresses
the database schema in a database-independent way by using JDBC datatypes instead of raw SQL
datatypes which are inherently database specific. An example of such a file is:
&?xml version="1.0"?&
&!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database.dtd"&
&database name="testdb"&
&table name="author"&
&column name="author_id"
type="INTEGER"
primaryKey="true"
required="true"/&
&column name="name"
type="VARCHAR"
required="true"/&
&column name="organisation"
type="VARCHAR"
required="false"/&
&table name="book"&
&column name="book_id"
type="INTEGER"
required="true"
primaryKey="true"
autoIncrement="true"/&
&column name="isbn"
type="VARCHAR"
required="true"/&
&column name="author_id"
type="INTEGER"
required="true"/&
&column name="title"
type="VARCHAR"
size="255"
defaultValue="N/A"
required="true"/&
&foreign-key foreignTable="author"&
&reference local="author_id" foreign="author_id"/&
&/foreign-key&
&index name="book_isbn"&
&index-column name="isbn"/&
&/database&
Learning more
There are essentially two ways to use DdlUtils:
build script via the task provided by DdlUtils.
You can learn more about .
From within your Java program, about which you can learn more
You're also welcome to join DdlUtils' .Access denied |
used Cloudflare to restrict access
Please enable cookies.
What happened?
The owner of this website () has banned your access based on your browser's signature (383b6a1c55f81f74-ua98).君，已阅读到文档的结尾了呢~~
扫扫二维码，随身浏览文档
手机或平板扫扫即可继续访问
利用ddlutil进行数据库迁移
举报该文档为侵权文档。
举报该文档含有违规或不良信息。
反馈该文档无法正常浏览。
举报该文档为重复文档。
推荐理由：
将文档分享至：
分享完整地址
文档地址：
粘贴到BBS或博客
flash地址：
支持嵌入FLASH地址的网站使用
html代码：
&embed src='/DocinViewer-4.swf' width='100%' height='600' type=application/x-shockwave-flash ALLOWFULLSCREEN='true' ALLOWSCRIPTACCESS='always'&&/embed&
450px*300px480px*400px650px*490px
支持嵌入HTML代码的网站使用
您的内容已经提交成功
您所提交的内容需要审核后才能发布，请您等待！
3秒自动关闭窗口DdlUtils 1.0 API Documentation
Frame Alert
This document is designed to be viewed using the frames feature. If you see this message, you are using a non-frame-capable web client.

我要回帖

更多关于 mysql 查看所有schema 的文章

 

随机推荐