Differences

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

--- sybase_sql_snippets [2009/11/11 21:00] – stephen
+++ sybase_sql_snippets [2017/01/01 20:05] (current) – external edit 127.0.0.1
@@ 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}}