On 7/6/2011 10:49 AM, Bill B wrote:
As Gregor indicated, MySQL Workbench. I use Visio, but that's because I
have it for other things, also.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On 7/6/2011 10:49 AM, Bill B wrote:
I should also add for something like this bloatware isn't as bad as
other times. I don't need to use it much.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On 2011-07-06 16:49, Bill B wrote:
Have a look at Schemaspy (http://schemaspy.sourceforge.net/).


/Lennart

On 2011-07-06 13:14, David wrote:
[...]
You can use different types of table in a database, so even if all other
tables are myisam you can create innodb tables

It's a shorter version of:

foreign key ...
references ...

or

constraint ... foreign key ... references ...

I actually prefer the last one since one can name the constraint that way.

but if you are stuck with myisam it won't do you any good. One highly
annoying "feature" with myisam is that it gladly accepts the syntax, but
silently ignores it.

[...]

It might have been a badly chosen word, but the meaning is that you have
a set of values that defines a domain. Example:

create table genders (
gender_code smallint not null primary key
);

-- as defined in ISO-5218
insert into genders (gender_code) values (0),(1),(2),(9);



Now you can reference genders from for example your employees table:

create table employees (
...
gender_code smallint not null references genders (gender_code),
...
);


In some sense genders is the domain for gender_code


/Lennart