TravisLaborde
IS-IT--Management
I'm trying to use Visio to do a Database Diagram from a SQL Server 2000 database.
Some tables come in fine, but one in particular just doesn't. What I'm doing is using the "reverse engineering" method to import table definitions, so that I can place them on my visio pages...
In particular, I have a table "users" which has a primary key of "user_id." When I import this table, the user_id field shows up as a normal (required - boldface) field, but not as a primary key. On other tables, the primary key is shown "above the line" with the letters "PK" to the left, showing visually that this is the primary key of the table.
I have verified that this field is indeed the primary key at the database level
Can anyone offer any ideas please?
Thanks,
Travis
Some tables come in fine, but one in particular just doesn't. What I'm doing is using the "reverse engineering" method to import table definitions, so that I can place them on my visio pages...
In particular, I have a table "users" which has a primary key of "user_id." When I import this table, the user_id field shows up as a normal (required - boldface) field, but not as a primary key. On other tables, the primary key is shown "above the line" with the letters "PK" to the left, showing visually that this is the primary key of the table.
I have verified that this field is indeed the primary key at the database level
Can anyone offer any ideas please?
Thanks,
Travis