Database Properties |
To access the properties of your database dictionary, select the dictionary tab on your project explorer. Open the databases and right-click on the database dictionary and select Properties from the right-click menu.
You can also view database properties by right-clicking on a database
diagram and selecting Edit 
<Your Database's
Name>.
You can change the database type of your database dictionary even after defining tables within that dictionary. This is useful if you change your mind about which database platform is appropriate for your project, or if you need to convert an existing database to a new platform. Existing columns within the database design will be altered to the equivalent data-type within the new database type. For example, when you convert a SQL Server database to Access, nvarchar will be converted to Text. If the database is then converted back to SQL Server the field will be converted to varchar.
SQL Server and Oracle databases can have stored procedures & views. Stored procedures consist of a set of SQL statements and may have input and output parameters. Views consist of a single SQL statement that returns 'virtual' table.
Some databases, like SQL Server, allow you to set up user-defined data-types. These can help to make your database design meaningful and will make sure that the data that is stored is valid for your purposes. Visual Case supports the use of user-defined data-types provided that they are manually set-up in both your physical database and your database dictionary.
Related Topics: