Generating Spatial Reference System DDL Commands

Generate data description language for one or more spatial reference systems. The DDL code can be a useful reference and training tool.

Prerequisites

Database Version	Spatial Reference System Privileges
SAP Sybase IQ 15.3 and 15.4	None.
SAP Sybase IQ 16.0	None.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Spatial Support, and then select Spatial Reference Systems.
Select one or more spatial reference systems from the right pane and either:
- Click the arrow to the right of the name and select Generate DDL, or
- From the Administration Console menu bar, select Resource > Generate DDL.
Tip: Use Shift-click or Control-click to select multiple spatial reference systems.
The DDL view opens, showing the SQL code used to create the selected spatial reference systems.