Sybase 中找出函數,視圖,觸發器,資料表

簡單記錄一下,版本不同可能有差別.

# 只知道部份字眼
SELECT * FROM sysobjects WHERE name LIKE '%關鍵字%'

# 列出所有函數 (FUNCTION)
SELECT * FROM sysobjects WHERE type = 'P'

# 列出所有視圖 (VIEW)
SELECT * FROM sysobjects WHERE type = 'V'

# 列出所有觸發器 (TIGGER)
SELECT * FROM sysobjects WHERE type = 'TR'

# 列出所有觸發器 (USER TABLE)
SELECT * FROM sysobjects WHERE type = 'U'