Sybase ASE viewの定義 確認
カラム定義確認 (sp_help)
sp_help docomo_mail -- Name Owner Object_type Object_status Create_date -------------------------------------------- -------------------- -------------------------------------------- ---------------------------------------------------- ---------------------------------------------------------------------------- docomo_mail dbo view -- none -- Feb 6 2014 1:12AM (1 row affected) Column_name Type Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity ------------------------------------------------ ---------------------------- ------------------------ ---------------- -------------------- -------------------- -------------------------------------------------------- ------------------------------------------------ ------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------------------------------- ---------------------------------------- mail_address varchar 255 NULL NULL 0 0 NULL NULL NULL NULL 0 No defined keys for this object. (return status = 0)
create文を確認 (sp_helptext)
sp_helptext docomo_mail
--
# Lines of Text
---------------
1
(1 row affected)
text
--------------------------------------------------------------------------------------
create view docomo_mail as select mail_address from t4 where mail_address like '%docomo.ne.jp'
(1 row affected)
(return status = 0)
