search

Home >Database >Mysql Tutorial >PowerDesigner导出脚本里包含视图_MySQL

PowerDesigner导出脚本里包含视图_MySQL

WBOY
WBOYOriginal
2016-06-01 13:36:441265browse

bitsCN.com

PowerDesigner导出脚本里包含视图

 

打开使用MySQL5.0的PDM之后，在菜单里选择

Database-> Edit   Current   DBMS.. 

确认DBMS使用的是MySQL5.0 

打开左端树状结构Script-> Objects-> View 

 

选中Create，在右端的Value中写入 

 

create   VIEW   [%R%?[   if   not   exists]]   %VIEW% 

  as 

%SQL% 

选中Drop，在右端的Value中写入

 

drop   table   if   exists   %VIEW% 

 

选中Enable，在右端的Value中选择Yes 

确定保存。

bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysql数据库权限控制_MySQLNext article：postgresql转mysql工具_MySQL

Related articles

See more