class Dbsketch::Rendering::SQL::IndexRenderer

Public Instance Methods

create(index) click to toggle source
# File lib/dbsketch/rendering/sql/index_renderer.rb, line 13
def create index
        ### Preconditions
        raise ArgumentError, "index is not a Dbsketch::Model::Index" unless index.is_a? Dbsketch::Model::Index
        ###
        "create index #{index.name} on #{index.target.name} (#{index.columns.map {|c| c.name }.join(", ")})"
end
drop(index) click to toggle source
# File lib/dbsketch/rendering/sql/index_renderer.rb, line 20
def drop index
        ### Preconditions
        raise ArgumentError, "index is not a Dbsketch::Model::Index" unless index.is_a? Dbsketch::Model::Index
        ###
        "if exists(select * from sysindexes where name = '#{index.name}') drop index #{index.name} on #{index.target.name}"
end