VIEW

CREATE VIEW dbo.usr
AS
SELECT          id AS ユーザID, name AS 名前, kana AS カナ, nickname AS ニックネーム, 
                      addr1 AS 住所１, addr2 AS 住所２, mail AS メールアドレス, 
                      mobile_tel AS 携帯, addr3 AS 住所３, post_no AS 郵便番号, 
                      tel AS 電話番号
FROM            dbo.usr_origin