general guidance on relational integrity.
I'm setting up a reasonably small DB with 30 or so
tables for a machine control application. Several of
the tables will have referential links to each other
(e.g. a finished part table will link to a master
part type table via the product ID number).
None
SQL
Server.
Upscene Productions
http://www.upscene.com
I need so general guidance on relational integrity.
I'm setting up a reasonably small DB with 30 or so
tables for a machine control application. Several of
the tables will have referential links to each other
(e.g. a finished
I need so general guidance on relational integrity.
I'm setting up a reasonably small DB with 30 or so
tables for a machine control application. Several of
the tables will have referential links to each other
(e.g. a finished part table will link to a master
part type table via the product ID
icing on
the cake. For the application you describe I think you will do fine
with either table type.
John A. McCaskey
-Original Message-
From: Roy Harrell [mailto:[EMAIL PROTECTED]
Sent: Monday, July 19, 2004 2:03 PM
To: [EMAIL PROTECTED]
Subject: Relational Integrity
I need so general
Roy,
MyISAM tables also support the FULLTEXT index type, which may be useful,
whereas InnoDB doesn't.
Lachlan
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 7:50 AM
To: Roy Harrell; [EMAIL PROTECTED]
Subject: RE: Relational Integrity
Integrity
Roy,
MyISAM tables also support the FULLTEXT index type, which may be useful,
whereas InnoDB doesn't.
Lachlan
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 7:50 AM
To: Roy Harrell; [EMAIL PROTECTED]
Subject: RE: Relational Integrity
