Module | Sequel::MSSQL::DatabaseMethods |
In: |
lib/sequel/adapters/shared/mssql.rb
|
AUTO_INCREMENT | = | 'IDENTITY(1,1)'.freeze |
SQL_BEGIN | = | "BEGIN TRANSACTION".freeze |
SQL_COMMIT | = | "COMMIT TRANSACTION".freeze |
SQL_ROLLBACK | = | "ROLLBACK TRANSACTION".freeze |
SQL_ROLLBACK_TO_SAVEPOINT | = | 'ROLLBACK TRANSACTION autopoint_%d'.freeze |
SQL_SAVEPOINT | = | 'SAVE TRANSACTION autopoint_%d'.freeze |
TEMPORARY | = | "#".freeze |
Microsoft SQL Server supports using the INFORMATION_SCHEMA to get information on tables.
# File lib/sequel/adapters/shared/mssql.rb, line 19 19: def tables(opts={}) 20: m = output_identifier_meth 21: metadata_dataset.from(:information_schema__tables___t). 22: select(:table_name). 23: filter(:table_type=>'BASE TABLE', :table_schema=>(opts[:schema]||default_schema||'dbo').to_s). 24: map{|x| m.call(x[:table_name])} 25: end