Skip to content

Instantly share code, notes, and snippets.

View 284km's full-sized avatar

Kazuma Furuhashi 284km

View GitHub Profile
SELECT column_name AS [Name],
IS_NULLABLE AS [Null?],
DATA_TYPE + '(' + CASE
WHEN Cast(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(5)) = -1 THEN 'Max'
ELSE Cast(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(5))
END + ')' AS [Type]
FROM INFORMATION_SCHEMA.Columns
WHERE table_name = 'table_name_here'
gem をインストールして spec_helper.rb に
require "simplecov"
SimpleCov.start "rails"