There are two ways for creating a schema. The first is to create all fields manually. For detailed information on how to create a field see chapters Designing Field and Managing.

Second, faster, more efficient and more attractive option for creating a schema is to retrieve schema from a data source object. It is possible to retrieve schema from tables, views, stored procedures, etc. To import schema from data source object:

1. Select Schema node in the Component Browser.
2. Define the location of data source object by selecting appropriate Server and Connection Key in section Designer Connection.
3. Click button View in the toolbar at the top of Selected Element Properties section and select the desired data source object type.
4. Select the desired data source object from the list of objects in the bottom list. 
5. Click Browse button in the toolbar. 
6. Schema appears on the right side of the screen. *
7. Click Attach. 
8. Click Yes in order to override any previous field definitions. 
9. Click Yes in order to retrieve field constraints.
10. Click OK to confirm schema creation. New fields are located in the tree list under the node Schema.

* Schema can be retrieved from a data source objects that return a result set.

See Also