SQL Studio Objects (SAP Library - SQL Studio: SAP DB 7.4)

SQL Studio Objects

You can store SQL statements and drafts of database tables as SQL Studio objects in the database locally in the Local Folder subdirectory. This means that you can use the objects at a later date.

Procedure

To create a new folder for SQL Studio objects in the database using the Catalog Manager, choose Catalog Manager ® New ® Folder.

To create SQL statements and store them as SQL Studio objects, use the SQL dialog, the Form dialog or the Visual Query dialog.

To store drafts of database tables as SQL Studio objects, create the table definition with the Catalog Manager.

To edit a stored SQL Studio object, select the object and choose Catalog Manager ® Show.

Note

You can enter the path for the Local Folder in the user profile settings.