#NEWLINE# def visit_create_index( self , create , include_schema = False ) : #NEWLINE# #INDENT# index = create . element #NEWLINE# self . _verify_index_table ( index ) #NEWLINE# preparer = self . preparer #NEWLINE# text = 'CREATE ' #NEWLINE# if index . unique : #NEWLINE# #INDENT# text += 'UNIQUE ' #NEWLINE# #UNINDENT# if index . dialect_options [ 'mssql' ] [ 'clustered' ] : #NEWLINE# #INDENT# text += 'CLUSTERED ' #NEWLINE# #UNINDENT# text += ( 'INDEX %s ON %s (%s)' % ( self . _prepared_index_name ( index , include_schema = include_schema ) , preparer . format_table ( index . table ) , ', ' . join ( ( self . sql_compiler . process ( expr , include_table = False , literal_binds = True ) for expr in index . expressions ) ) ) ) #NEWLINE# if index . dialect_options [ 'mssql' ] [ 'include' ] : #NEWLINE# #INDENT# inclusions = [ ( expr . table . c [ col ] if isinstance ( col , util . string_types ) else col ) for col in index . dialect_options [ 'mssql' ] [ 'include' ] ] #NEWLINE# text += ( ' INCLUDE (%s)' % ', ' . join ( [ preparer . quote ( c . name ) for c in inclusions ] ) ) #NEWLINE# #UNINDENT# return text