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