sqlread.txt

c#设计模式WithCla

SQL Code Generation Script to generate SQL tables
These scripts are "getting started" scripts that must be updated for your development environment.


1. Use Shlaer Mellor Methodology with arrow heads for 1:1, 1:M, and M:M
2. Create a class with all SQL data types, e.g. name CHAR, age NUM to update wc2.ini
3. Enter attribute size and constraints, e.g. (10) in ATTRIBUTE_USER1 text box
4. Check Index Box for all attributes that are a key or index
5. Enter index keywords, e.g. UNIQUE CLUSTERED in ATTRIBUTE_USER2
6. Place other SQL statements into CLASS_USER1, CLASS_USER2, and CLASS_USER3.
7. Select "Utilities - Generate Class Code/Report" and select SQL1.SCT script
8. Please send script improvements to MicroGold [e-mail] 
   info Richard Felsinger [e-mail]