社区
Sybase
帖子详情
generate Database Objects DDL与generate 'create database' DDL的区别
bianchenglangzigwd
2003-06-22 10:38:28
请问在sybase center中右键单击数据库时有两个选项,generate Database Objects DDL与generate 'create database' DDL有什么区别
...全文
49
1
打赏
收藏
generate Database Objects DDL与generate 'create database' DDL的区别
请问在sybase center中右键单击数据库时有两个选项,generate Database Objects DDL与generate 'create database' DDL有什么区别
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
1 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
stweiguo
2003-06-22
打赏
举报
回复
generate Database Objects DDL 是创建整个数据库及其表\存储过程等的脚本
generate 'create database' DDL 仅是创建数据库的脚本(不包含表等)
你试一下不就知道了吗?
Sybase数据库备份方案.txt
1、数据结构备份 在windows平台的Sybase SQL Server Manager(数据库管理)平台中选择Serverà
Generate
ddl
则产生整个数据库服务器的所有信息,如果选择
database
à
generate
ddl
则产生所选定数据库的信息,以master库为例,产生的文件主要包括:config.
ddl
(配置)、devices.
ddl
(设备)、
database
.
ddl
(数据库)、logins.
ddl
(用户)、remote.
ddl
(远程)、cache.
ddl
(缓冲)、segment.
ddl
()、group.
ddl
(用户组)、user.
ddl
(用户)、default.
ddl
(确省)、rule.
ddl
(规则)、udt.
ddl
、table.
ddl
(表)、view.
ddl
(视图)、proc.
ddl
(存储过程)、triger.
ddl
(触发器)。 2、数据记录备份
staruml-
ddl
:用于
DDL
生成的StarUML 3扩展
StarUML的
DDL
扩展 StarUML的此扩展( )支持从ERD生成
DDL
(数据定义语言)。 从StarUML的扩展管理器安装此扩展。 如何使用 单击菜单( Tools >
DDL
>
Generate
DDL
... ) 选择将要生成到
DDL
的数据模型。 将生成的
DDL
保存到文件。 生成规则 以下是从ERD元素转换为
DDL
的规则。 转换所有实体和列以创建表语句,如下所示:
CREATE
TABLE entity1 ( col1 INTEGER , col2 VARCHAR ( 20 ), ... ); 主键的转换如下:
CREATE
TABLE entity1 ( pk1 INTEGER , pk2 VARCHAR ( 10 ), ... PRIMARY KEY (pk1, pk2, ...) ); 非空列的转
DB2常用命令和用法
DB2常用命令和用法DB2常用命令和用法DB2常用命令和用法DB2常用命令和用法
《SQL数据库管理工具》(Richardson Software RazorSQL)v5.1.1/含注册机
软件简介:RazorSQL 是数据库查询工具、SQL的编辑、数据库管理工具,可以通过ODBC,JDBC连接数据库,已经证实可以使用的数据库种类,达到了29种. RazorSQL is an SQL query tool,
database
browser, SQL editor, and
database
administration tool for Windows, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 29
database
s, can connect to
database
s via either JDBC or ODBC, and includes support for the following
database
s Enhanced Feature Set Standard Feature Set DB2 Ingres Pervasive Cache Mimer SQL Derby InterBase PostgreSQL Daffodil Netezza Firebird JavaDB SQLite DBASE Paradox FrontBase MS SQL Server SQL Anywhere FileMaker PointBase H2 MySQL Sybase (ASE) Mckoi Solid HSQLDB OpenBase Teradata Microsoft Access Informix Oracle Features * A
Database
Navigator for browsing
database
object
s. * An SQL Editor for creating SQL queries. * Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences * Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers * A robust programming editor that embeds the powerful EditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more. * Export Tool - Export data in various formats * Import Tool - Import data from delimited files, Excel files, or fixed width files into tables * Ships with a built-in relational
database
engine (HSQLDB) that is up and running out of the box and requires no end-user administration * A
Generate
DDL
Tool for generating table, view, and index
DDL
. * Table / SQL Query Compare tool for comparing tables or queries across multiple connections *
Database
Data Search tool for searching single or multiple
database
table and view data. *
Database
Object
Search tool for searching for
database
object
s. * Backup tools such as the
Database
Backup Tool and Table Backup Tool * Auto column and auto table lookup * SQL Formatter * SQL Query builder tool * SQL Query Scheduler tool * Command Line Interface * PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server
database
s remotely via PHP enabled web servers * An ASP bridge for connecting to MS SQL Server
database
s remotely via ASP enabled web servers * SQL GUI Tools for generating SQL for various operations * Edit, delete, and insert
database
data with the
Database
Editor * Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS * Tested with Apache Derby / JavaDB, Daffodil DB, DB2, DBASE, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata
最完整的Toad For Oracle使用手册
1073页啊,够爽吧: Introduction 15 New in This Release 15 Introduction to Toad 23 DB Admin Module 24 Toad and Oracle Enterprise Manager 29 Quick Search Bar 30 Additional Resources 31 Working with other Quest Products 32 Knowledge Xpert 32 Using SQL Optimizer with Toad 32 Benchmark Factory 33 Quest Code Tester Integration 35 Toad Basics 37 Toad Tips 37 Errors 37 RAC Support 37 Task Bar & Status Bar 38 Toolbars, Menus and Shortcut Keys 40 Installation and Administration of Toad 64 Window Privileges and Toad 64 Toad for Oracle, Read-Only 64 Registering Toad 65 Silent Installation 66 Group Policy Management 71 Citrix Support 71 SQL*Net Versions 72 Configuration Files 73 Server Side
Object
s Installation 93 Connecting to Oracle 97 Server Login Window 97
Create
New Connection 99 Selecting Connection Color 101 SET ROLE 101 Auto Connect 103 Save Passwords for Connections 104 Select and View Favorite Connections 104 Organize your login display 105 Use Existing Connection 106 SQLNET Editor 106 LDAP Editor 107 Oracle Homes 108 TNSNames Editor 111 Tutorials 119 CodeXpert 119 PL/SQL Debugger 121 SQL*Loader 140 Team Coding 158 RMAN Templates 164 RMAN Scripts in Toad 164 Working with RMAN Templates 164 Executing RMAN Scripts from Toad 165 Comparing 166 Data Duplicates 166 Compare Single
Object
s 166 Comparing
Database
s 167 Comparing Data 174 Compare Files (Difference Viewer) 176 Comparing Schemas 180 Controlling Sessions 188 Select Session 188 End Connections 188 Test Connections 188 Configure User Lists 188 Session Information 189 Change Password 190 Commit & Rollback 190 Connect and Disconnect 191 DBMS_Flashback 191 Diagnosing Problems 193 View Extents 193 Identify Space Deficits 193 Log Switch Frequency Map 194 Tablespace Map 194 TKProf Interface Wizard 196 Undo Advisor 198 Segment Advisor 200 LogMiner Interface 203 Health Check 207 Trace File Browser 226 CodeXpert 231
Database
Administration 259 Audit SQL/Sys Privs 259 NLS Parameters 260 Toad Features Security 260 ASM Manager 263 Audit
Object
s 269 Multiple
Object
Privileges 270 Oracle Parameters 272 Tablespaces 274 Redo Log Manager 282 Importing and Exporting Data 285 Data Pump 285 Export Dataset 304 Export
DDL
310 Export File Browser 318 General Export 324 General Import 329
Generate
Database
Script 341
Generate
Schema Script 342 Managing Projects 346 Using Automation Designer to Control Toad 346 Project Manager 387 Query Viewer 416 SQL Command Recall 418 Script Manager 419 Monitoring 431 Toad Server Statistics 431 SQL Monitor 432 Toad UNIX Monitor 432 ADDM/AWR 434
Database
Browser 446
Database
Monitor 449
Database
Probe 453 Index Monitoring 458 Instance Manager 460 Session Browser 466 SGA Trace/Optimization 483 StatsPack Browser 486 Top Session Finder 495 Optimizing (Tuning) 499 DBMS_REDEFINITION Wizard 499 Estimate Index Size 500 Estimate Table Size 501 Explain Plan 503 Pinned Code 504 Repair Chained Rows 505 Rebuild Table 506 Unix Kernel Parms 507 Windows Registry Parms 508 Analyze All
Object
s 509 Profilers 512 Oracle Tuning 523 Rebuild Multiple
Object
s 525 Options 535 Formatting Options 535 Toad Options 536 Language Management 603 Printing 620 Printing 620 Print Grid 620 Report Link Designer 620 Reporting 623 Toad Control Files 623 Dependencies 624 ER Diagrams 624 Explain Plans 631 Code Road Map 636 HTML Schema Doc Generator 641 Master/Detail Browser 643 Reports Manager 648 Reporting from Data Grids 655 Spool SQL 659 Spool SQL 659 Utilities 660 Archive 660 Wrap Code 660 Service Manager 661 External tools 662 FTP 665 Java Manager 668 Network Utilities 672 Task Scheduler 676 Unix Job Scheduler 678 Source Control and Team Coding 693 Support for Version Control Products 693 Third Party File Based Source Control 694 Team Coding 697 Status in the Editor Status Bar or Team Coding Viewer Status Column 707 Detailed File Properties 708 Checking
Object
s and Scripts in and out 709 Using Automatic Check-in and Automatic Check-out 709 Manually check-in or check-out 709 Entering Comments on Check in or out 710 Check In All 711 Undo Checkout 712 Freezing an
Object
713 TC Locks not selected 726 TC Locks selected 726 Working from the Command Line 738 Command Line Syntax 738 Converting Old Settings Files to Actions 743 Command Line Passwords 744 Export Tables, Views, SQL Queries from the Command Line 744 Run Analyze
Object
s from the Command Line 745 Run CodeXpert from the Command Line 750 Running Actions from the Command Line 751 Run Compare
Database
s from Command Prompt 754 Run Compare Schemas from a Command Prompt 757 Run Copy to another Schema from Command Prompt 757 Run
Generate
Database
Script from a Command Prompt 758 Run
Generate
Schema Script from Command Line 760 Run Rebuild
Object
s from the Command Prompt 762 Run Reports Manager from the Command Line 766 Using Variables 768 Using Variables 768 Working with Code 769 Editor 769 Debugging 819 Query Builder 851 Working with Data 861 Column Names Supported 861 Graph Properties 861 OPS$ Accounts 861 Viewing or Hiding Docked Windows 862 Viewing Source Surrounding a PL/SQL Error 863 Dataset Operations 864 Data Grids 866 DBMS Output 881 Finding Data 883
Generate
Test Data 890 Working with
Database
Object
s 896 Schema Browser Overview 896 Auto-Refreshing the Datagrid 897 Icon Legend 898 Privileges 898 Schema Browser Toolbars 899 Statement Processing 900
Create
Object
s in Another Schema 900 Personalizing the Schema Browser 900 General Schema Browser Actions 903 Browser Filters 907 Clusters 912 Constraints 914 Contexts 917 DB Links 918 Dimensions 920 Directories 921 Favorites 923 Flashback Archives 924 Functions 926 Indexes 928 Invalid
Object
s 929 Java 931 Jobs 933 Libraries 936 Materialized Views (Snapshots) 938 Materialized View (Snapshot) Logs 940 Oracle Scheduler 941 Packages 953 Policies 955 Policy Groups 956 Procedures 957 Profiles 959 Queue Tables 960 Queues 964 Recycle Bin 966 Refresh Groups 968 Resource Consumer Groups 970 Resource Plans 972 Roles 974 Rollback Segments 975 Sequences 977 Synonyms 978 System Privileges 980 Tables 981 Tablespaces 996 Triggers 1002 Types 1004 Users 1010 Views 1012 Troubleshooting 1017 Unicode Troubleshooting 1017 Hints and Tips: Connecting To Personal Oracle 1018 Hints and Tips: Table Does Not Exist Errors 1019
Create
Support Bundles 1019 Toad Advisor 1019 Contact Quest 1021 Contact Quest Support 1021 Contact Quest Software 1021 About Quest Software, Inc 1021 Appendix: Contact Quest 1022 Contact Quest Support 1022 Contact Quest Software 1022 About Quest Software, Inc 1022 Index 1023
Sybase
2,596
社区成员
25,614
社区内容
发帖
与我相关
我的任务
Sybase
Sybase相关技术讨论区
复制链接
扫一扫
分享
社区描述
Sybase相关技术讨论区
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章