CREATE SPATIAL INDEX index_name 
  ON <object> ( spatial_column_name )
    {
       [ USING <geometry_grid_tessellation> ]
          WITH ( <bounding_box> 
                [ [,] <tesselation_parameters> [ ,...n ] ] 
                [ [,] <spatial_index_option> [ ,...n ] ] ) 
     | [ USING <geography_grid_tessellation> ] 
          [ WITH ( [ <tesselation_parameters> [ ,...n ] ]
                   [ [,] <spatial_index_option> [ ,...n ] ] ) ]
    } 
  [ ON { filegroup_name | "default" } ]

CREATE [ PRIMARY ] XML INDEX index_name 
    ON <object> ( xml_column_name )
    [ USING XML INDEX xml_index_name 
        [ FOR { VALUE | PATH | PROPERTY } ] ]
    [ WITH ( <xml_index_option> [ ,...n ] ) ]

spatial example:
CREATE TABLE SpatialTable (id int primary key, geometry_col geometry)
GO
CREATE SPATIAL INDEX spatialindex
   ON SpatialTable(geometry_col)
   WITH ( BOUNDING_BOX = ( 0, 0, 500, 200 ) )

xml example:
CREATE TABLE dbo.testtableindexxml  ( id int NOT NULL, name varchar(25) NULL, colxml xml NULL,
    CONSTRAINT pkind PRIMARY KEY(id))
    ON [PRIMARY]
GO
CREATE PRIMARY XML INDEX textxmlindex ON dbo.testtableindexxml (colxml)
GO

these indexes will not show up under there tables, but will show up under all index folder, and if scripted will be all wrong...