Differences

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

--- sybase_sql_snippets [2009/11/11 20:58] – 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    1 = 1
-AND      sysobjects.type = 'U' -- user table
+--AND      sysobjects.type = 'U' -- user table
-AND      sysobjects.type = 'V' -- view
+--AND      sysobjects.type = 'V' -- view
-AND      sysobjects.type = 'L' -- log
+--AND      sysobjects.type = 'L' -- log
-AND      sysobjects.type = 'P' -- procedure
+--AND      sysobjects.type = 'P' -- procedure
-AND      sysobjects.type = 'R' -- rule
+--AND      sysobjects.type = 'R' -- rule
-AND      sysobjects.type = 'D' -- default
+--AND      sysobjects.type = 'D' -- default
-AND      sysobjects.type = 'TR' -- trigger
+--AND      sysobjects.type = 'TR' -- trigger
-AND      sysobjects.type = 'RI' -- referential constraint
+--AND      sysobjects.type = 'RI' -- referential constraint
 ORDER BY sysobjects.name
 </code>
@@ Line 25: / Line 25: @@
 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}}