Sybase ADDICT

Sybase tips, howto and technical informations – All in a blog !
  • Home
  • Sybase Downloads
  • Sybase Related Links
  • Sybase Jobs


  


  • Find out all “Defined Rules” in a Sybase ASE database

    January 10th, 2010 @ 3:02 PM by Jean-Francois LEBON | Be the 1st to comment

    The following transact-sql code will help you to find all defined rules in a Sybase ASE database.

    select sysobjects.name as "rule name",
    object_name(syscolumns.id) as "table name",
    syscolumns.name as "column name"
    from sysobjects, syscolumns
    where object_name(syscolumns.domain)=sysobjects.name
    and sysobjects.type = 'R'
    go
    

    The output displays the table and column to which the rules are bound.


    Tags: ase, howto, sql, sybase, Sybase Adaptive Server Enterprise, tips, transact-sql

  • Previous post
    Next post


  • No Comments »

    No comments yet.

    RSS feed for comments. TrackBack URL

    Something to say ? Leave a comment...

    You must be logged in to post a comment.



Categories:

  • Review
  • Sybase Adaptive Server Enterprise
  • Sybase Adaptive Server IQ
  • Sybase Articles
  • Sybase HowTo
  • Sybase News
    • End of Life Notice
    • General News
  • Sybase Replication Server
  • Sybase Tips & Tricks
  • Sybase Transact-SQL Code
  • Videos/Podcasts/Webcasts

Quick Links:

  • Sybase quick refence
  • Sybase Bookmarks
  • Sybase Team Forums
  • Sybase Inc
  • International Sybase User Group
  • CodeXchange
  • SQL Anywhere question and answer
  • Sybase Jobs [US]
  • Sybase News for Sybase Experts

See my Resume:

  • View Jean-Francois LEBON's profile on LinkedIn

Archives:

  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • September 2009
  • July 2009
  • May 2009
  • April 2009
  • January 2009
  • December 2008
  • October 2008
  • September 2008
  • May 2008

Sybase ADDICT:

  • Register
  • Log in
  • RSS Feed
article ase asiq End of Life Notice General News howto iq news performance podcast powerbuilder replication replication server Review screencast sql sybase Sybase Adaptive Server Enterprise Sybase Adaptive Server IQ Sybase Articles Sybase HowTo Sybase News Sybase Replication Server Sybase Tips & Tricks Sybase Transact-SQL Code tips transact-sql video Videos/Podcasts/Webcasts
© Sybase-ADDICT.com - All Rights Reserved. Entries RSS Comments RSS Login sybase addict