module Spectacles::SchemaStatements::SQLServerAdapter
Public Instance Methods
view_build_query(view, name = nil)
click to toggle source
# File lib/spectacles/schema_statements/sqlserver_adapter.rb, line 12 def view_build_query(view, name = nil) q =<<-ENDSQL SELECT view_definition FROM information_schema.views WHERE table_name = '#{view}' ENDSQL q = select_value(q, name) or raise "No view called #{view} found" q.gsub(/CREATE VIEW .*? AS/i, "") end