OLD Creating a Schema V2.0

Open Studio

  1. Expand the Jobs node, right click on Unassigned tasks and select New Task.
     
  2. Create a Workflow Stored Procedure Task and give it a Name e.g. Create SDW Schema
     
  3. Select the Spatial Data Warehouse Connection, Click on the All radio button and select the Function astun.sdw_new_schemaFrom v6.0.0 select astun from the Function filter and pick sdw_new_schema
     
  4. Select the schemaname parameter and enter the name of your schema in the Edit parameter box. Then select the staffaccess parameter and enter true.

    Note: Change "true" to "false" for a private schema.

  5. Click the Run button  to run the task. You should see the dialog SPTask 'Create SDW Schema' completed successfully. Click OK.
     
  6. Click Save to save your new task details.

  7. Your next step is to Assign Access Rights to the Schema.