Hi LiJian,
You can define any schema object your DB supports, including all of the above, via SQL scripts executed using an SQL admin tool supported by the DB in question (might be provided with the DB or a 3rd party one) - see your DB docs/support for details regarding these tools.
As you probably know, Tersus can create tables and set their primary key columns (see http://www.tersus.com/?Id=1607) automatically, but this feature is actually intended for the initial phase of learning Tersus modelling.
It is recommended that once you start developing real-world apps, which will probably require some of the features you've mentioned, you should disable the Tersus auto-create feature by adding the following to your Configuration.xml and tomcat context file:
And use external sql scripts to create all of the schema (including tables & primary keys).
Note that to execute stored procedures use Database/Call Procedure - see http://www.tersus.com/?Id=7010
Regards,
David
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
