Database objects creation tasks

This table shows how you can create various database objects in System i® Navigator.

Table 1. Creating database objects
Tasks	Objects whose context menu supports the task	Available from object context menus in the Web interface	System i Navigator utilities
Create a constraint on a table		N/A, but the task is available from the Table Definition window in the Web interface.	The Table Definition window A Database Navigator map
Create a distinct type or an array type	A schema object The All Objects folder The Types folder	Yes
Create a function	A schema object The All Objects folder The Functions folder A function object	No
Create a global variable	A schema object The All Objects folder The Global Variables folder	Yes
Create a journal	A schema object The All Objects folder The Journals folder	N/A, but the task is available from the Journal Management window in the Web interface.	A Database Navigator map
Create an alias	A schema object The All Objects folder The Alias folder A table object A table partition A view object	Yes	A Database Navigator map
Create an index	A schema object The All Objects folder The Indexes folder A table object A table partition	Yes	A Database Navigator map Index Advisor An SQL performance monitor analysis result Visual Explain
Create an SQL package	A database folder	No	The Run SQL Scripts window ¹
Create a procedure	A schema object The All Objects folder The Procedures folder	No
Create a schema	The Schemas folder	Yes
Create a sequence	A schema object The All Objects folder The Sequences folder	Yes
Create a table	A schema object The All Objects folder The Tables folder	Yes	A Database Navigator map
Create a trigger	A schema object The All Objects folder The Triggers folder A table object A view object	Yes	A Database Navigator map
Create a view	A schema object The All Objects folder The views folder	Yes	A Database Navigator map
Create multiple indexes with Run SQL Scripts²			Index Advisor
Create an OmniFind text search index	A schema object An OmniFind Text Indexes folder The All Objects folder	Yes
Note: ¹ To create an SQL package from the Run SQL Scripts window, select Connection > JDBC Settings from the menu, and then select the Enable extended dynamic (SQL package) support check box on the Package tab. ² To create multiple indexes with Run SQL Scripts, right-click the advised indexes in the Index Advisor window and select Show SQL. This launches the Run SQL Scripts window that contains the CREATE INDEX statements for each index selected.