Differences

This shows you the differences between two versions of the page.

--- sybase_sql_snippets [2009/11/04 20:54] – stephen
+++ sybase_sql_snippets [2017/01/01 20:05] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Sybase SQL Snippets ======
-===== Show All User Tables =====
+===== Get Info from SysObjects =====
 <code sql>
 SELECT   *
 FROM     sysobjects
-WHERE    sysobjects.type = 'U'
+WHERE    1 = 1
+--AND      sysobjects.type = 'U' -- user table
+--AND      sysobjects.type = 'V' -- view
+--AND      sysobjects.type = 'L' -- log
+--AND      sysobjects.type = 'P' -- procedure
+--AND      sysobjects.type = 'R' -- rule
+--AND      sysobjects.type = 'D' -- default
+--AND      sysobjects.type = 'TR' -- trigger
+--AND      sysobjects.type = 'RI' -- referential constraint
 ORDER BY sysobjects.name
 </code>
@@ Line 15: / Line 23: @@
 FROM     syscolumns
 JOIN     sysobjects ON syscolumns.id = sysobjects.id
-WHERE    sysobjects.name = 'SG_PAX_TRACKING_SPT'
+WHERE    sysobjects.name = 'TABLE_NAME'
 ORDER BY syscolumns.name
+</code>
+===== Search All Column Names =====
+<code sql>
+SELECT   sysobjects.name
+         , syscolumns.name
+         , *
+FROM     syscolumns
+JOIN     sysobjects ON syscolumns.id = sysobjects.id
+WHERE    syscolumns.name like '%directive_id%'
+ORDER BY sysobjects.name ASC
+         , syscolumns.name ASC
 </code>
 {{tag>reference sybase sql code_snippet}}