More than 5 years have passed since last update.

テーブル名取得

SQLServer

Posted at 2016-06-03

select
     t.name    as テーブル名_物理名
    ,ep.value  as テーブル名_論理名
from
     sys.tables              t
    ,sys.extended_properties ep
where
    t.object_id = ep.major_id
    and ep.minor_id = 0
order by 1

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up