Creating Objects in s-Studio
You can create s-Server objects, such as foreign streams, foreign tables, native streams, tables, views, and pumps, directly through s-Server.
To create an object, right-click the object type's folder in s-Studio:
s-Studio opens a dialog box that lets you name the new object:
After you click OK, s-Studio opens the object with the Definition tab selected. For a foreign stream, you can select a server and add columns for the new stream. You can also add additional options through the Options section of the Definitions tab.
When you click Add in the Columns section, a dialog box opens that lets you define the column.
You can also view and edit the SQL for the new object by clicking the SQL tab: