System table to find out RULE definition

• sandhya_vemulla

  Say Hey Kid

  Points: 696

  More actions

  April 22, 2009 at 2:28 pm

  #208661

  Hi,

  if i use SP_HELPTEXT then i can see the definition of the RULE.

  Is there any where to see which System table stores the definition of the RULE.

  reagrds

  sandhya

• Lowell

  SSC Guru

  Points: 323518

  More actions

  April 22, 2009 at 5:59 pm

  #982614

  find any column that has been tied to a rule:

  select

  object_name(syscolumns.id) as tablename,

  syscolumns.name as columnname,

  object_name(syscolumns.domain) as RuleName,

  syscomments.TEXT as RuleDefinition

  from syscolumns

  inner join syscomments on syscolumns.domain = syscomments.id

  where syscolumns.domain > 0

  a rule that exists, but may or may not be tied to a column:

  select name as RuleName,

  syscomments.TEXT as RuleDefinition

  from sysobjects

  inner join syscomments on sysobjects.id = syscomments.id

  where sysobjects.xtype='R'

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• WayneS

  SSC Guru

  Points: 95460

  More actions

  April 22, 2009 at 7:47 pm

  #982622

  sandhya_vemulla (4/22/2009)

  ---

  Is there any where to see which System table stores the definition of the RULE.

  You are looking for the system view sys.all_sql_modules. Specifically the definition column.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2