Manual Dbdesigner

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 table columns

TheUser 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

Table Editor How to use the TableEditor 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 Options Export SQL Drops SQL Drops Options DatabaseConnections 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 function

Keyboard Short-Cuts Version History

Online Dokumentation Version1.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 andoptimized 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 an idea for new functions and features please visit fabforce.net.

Copyright2003 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 is not allowed. Preamble The licenses for most software are designed to take awayyour 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 other program whose authors commit to using it. (Some other Free Software Foundation software iscovered 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 for this service if you wish), that you receive source code or can get it if you want it, that youcan 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 for you if you distribute copies of the software, or if you modify it. For example, if you...