-
Would this be significantly smaller than the compact view that only shows primary keys and indexes?
Note that you should be able to write a simple script that removes all entries that aren't the table name from the relationships .dot file. Currently the only differentiation is that the table name comes first and has a (default) color of #9bab96.
Then recreate the .png with
dot...
2010-01-06 16:18:43 UTC by johncurrier
-
I have a quite complex schema and I would like a high level view.
Would be great to have:
* one page showing each table as a node - only with the table name - no columns etc
* edges between those tables that are related (edges are undirected, and related is determined if they have fk between each other)
Example (disregard whether it is probable or good - just to show the expected...
2010-01-05 09:34:18 UTC by julienaubert
-
It's open source, so you can do whatever needs to be done.
2009-12-28 16:22:42 UTC by johncurrier
-
John, thank you for your reply.
now, I have another question, is it possible if I modify the source code that I downloaded to get rid of some of the generated Tabs - such as Donate and Anomalies and the Generated By URL link. I am planning to keep the Generated By SchemaSpy text at the end of each page instead ?
Best regards
Zaf.
2009-12-24 21:32:57 UTC by https://www.google.com/accounts
-
Initially I had all of the options listed with -help. That quickly became impossible to deal with and to keep in sync with what the web site had.
The -noads option was explicitly not documented because I didn't want people to disable ads. However I plan on removing the ads completely in the future. They've resulted in barely $10 over the past couple of years. In other words: including...
2009-12-24 00:07:46 UTC by johncurrier
-
Ok, I discovered the -noads and -nologo swtiches when looking at the SchemaSpyGUI application. The -noads and -sso is not supported in the GUI app, but -noads and -nologo worked like a champ from the command line (using Linux ;).
Question: John, is there any way to display all available command line options (switches) ? I used the java -jar schema...jar -help but the info was limited...
2009-12-23 21:08:08 UTC by https://www.google.com/accounts
-
Is there any command line switch for the SchemaSpy not to include those google ads ? It is pain in the neck to go through each html file to clean them up.
appreciated.
2009-12-23 19:49:58 UTC by https://www.google.com/accounts
-
I don't think it'd be able to determine an implied relationship for your example. How would it know which was the implied foreign key?
John.
2009-11-30 19:54:47 UTC by johncurrier
-
John,
Use case is ...
- Table1.Staff_Code (nvarchar; PK for Table1)
- Table2.Staff_Code (nvarchar; PK for Table2)
.
Assuming I've not done something incorrectly, I expected SchemaSpy to show a relationship between Table1 and Table2, given Staff_Code was spelled the same in both tables and was the same data type.
Does SchemaSpy pass over this case because they are both PKs?.
2009-11-30 15:30:54 UTC by tdavis2
-
SchemaSpy can determine implied relationships if the column name and type match the column name and type of another table's primary key. The beta also supports Ruby on Rails naming conventions for determining implied relationships.
An alternative approach would be to use the -meta option to explicitly specify table relationships.
John.
2009-11-30 02:28:54 UTC by johncurrier
