Chapter 3 DBMS Reference Guide


Common entries for Rule

You can define values for the following common entries for the Rule object in the DBMS definition.

Entry Example (Sybase Adaptive Server Enterprise 11)
Enable Enable = Yes
Maxlen MaxLen = 30
Create
create rule  %RULE% as
%RULESEXPR%
Drop
if exists (select 1 from sysobjects where name='%RULE%' and type='R')
	drop rule  %RULE%
SqlListQuery
{@OBJTNAME ID, @OBJTCODE ID, SCRIPT ...}

select 
o.name,convert(char(20), o.id),t.text
from 
dbo.sysobjects o, dbo.syscomments t 
where 
[%SCHEMA%? o.uid=user_id('%SCHEMA%') and] o.type='R' 
and t.id=o.id and    t.texttype=0 
order by 
o.id,t.number,t.colid
SqlAttrQuery
ModifiableAttributes List of extended attributes that will be taken into account in the merge dialog box during database synchronization
ReversedStatements List of statements that will be reverse engineered

For a description of each of the common object entries, see section "Common object entries".

 


Copyright (C) 2005. Sybase Inc. All rights reserved.