サンプルページ

ページ

カテゴリーごとの投稿

SELECT
    v.name  AS view_name,
    c.column_id,
    c.name  AS view_column_name,
    t.name  AS view_data_type,
    c.max_length,
    c.precision,
    c.scale,
    c.is_nullable
FROM sys.views v
JOIN sys.columns c
    ON c.object_id = v.object_id
JOIN sys.types t
    ON t.user_type_id = c.user_type_id
WHERE v.name = N'あなたのビュー名'
ORDER BY c.column_id;