Dbdesigner4 Manual 1.0.42

PDF Documentation
Version 1.0.42
Copyright (C) 2003 by fabFORCE.net

General Information
License
Support
Bug submission

Fundamentals
Models and Databases
The User Interface
Modelling

Modelling
Tables and Relations
Place a new Table
Edit a Table
Create Table Indices
Make a relation

Querying
Building selects
Building a simple SQL SELECT
Joining tables
Selecting tablecolumns

The User Interface
Main Elements
The Main Menu
File Menu
Edit Menu
Display Menu
Database Menu
Plugins Menu
Options Menu
Windows Menu
Help Menu
Palettes
The Tools-Palette
The Navigator-Palette
Navigator-Page
Info-Page
The Datatypes-Palette
Common Datatypes
All Datatypes
Replace Datatypes
Reinitialise Datatypes
The DB-Model-Palette
The Statusbar

The Editors

TableEditor
How to use the Table Editor
Table Settings
Table Columns
Table Indices
Standard Inserts
Table Options
Advanced Table Options
Comments
Relation Editor
Region Editor
Note Editor
Image Editor
Dataype Editor
Query Editor

Database Creation and
Maintenance
Traditional SQL Export
What is DB Synchronisation?
What is Reverse Engineering?
Export SQL Creates
SQL Create OptionsExport SQL Drops
SQL Drops Options
Database Connections
Database Connection Dialog
Network Hosts Tree
Connection List
The User Section
Connection Parameter Dialog
Database Synchronisation
Synchronisation options
Executing the synchronisation
Reverse Engineering
Reverse Engineering options
Build Relations
Use Datatype substitution
Create Standard Inserts
Executing the functionKeyboard Short-Cuts
Version History

Online Dokumentation
Version 1.0.42

Copyright 2003 fabFORCE.net. All rights reserved.

General Information
DBDesigner 4 is a free available database design system that integrates database
design, modelling, creation and maintenance into a single, seamless environment.
It is written for Microsoft© Windows 2k/XP© and Linux KDE/Gnome to support both,the Windows and the Linux platform.
DBDesigner 4 is developed and optimized for the MySQL-Database.

License
DBDesigner is available for free download and is published under the GNU GPL License.
Click here to read through the GNU GPL License.

Support
Free support is available during beta test phase. Please navigate to fabforce.net.

Bug submission
If you have found a bug or got anidea for new functions and features please visit
fabforce.net.

Copyright 2003 fabFORCE.net. All rights reserved.

License
GNU GENERAL PUBLIC LICENSE
Version 2, June 1991

Copyright (C) 1989, 1991 Free Software Foundation, Inc.
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
Everyone is permitted to copy and distribute verbatim copies
of this license document, but changing it isnot allowed.
Preamble
The licenses for most software are designed to take away your freedom to share and
change it. By contrast, the GNU General Public License is intended to guarantee your
freedom to share and change free software--to make sure the software is free for all its
users. This General Public License applies to most of the Free Software Foundation's
software and to any otherprogram whose authors commit to using it. (Some other Free
Software Foundation software is covered by the GNU Library General Public License
instead.) You can apply it to your programs, too.
When we speak of free software, we are referring to freedom, not price. Our General
Public Licenses are designed to make sure that you have the freedom to distribute
copies of free software (and charge forthis service if you wish), that you receive source
code or can get it if you want it, that you can change the software or use pieces of it in
new free programs; and that you know you can do these things.
To protect your rights, we need to make restrictions that forbid anyone to deny you
these rights or to ask you to surrender the rights. These restrictions translate to certain
responsibilities...