Chapter 3 DBMS Reference Guide

Common entries for Index

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

Entry Example
Enable Enable = Yes
Maxlen Maxlen = 128
Create In Sybase ASA 8: 

create [%UNIQUE%] index %INDEX% on [%QUALIFIER%]%TABLE% (


%CIDXLIST%


)


[%OPTIONS%]
Drop 
if exists(select 1 from sys.sysindex I, sys.systable T
where I.table_id=T.table_id and I.index_name='%INDEX%' and T.table_name='%TABLE%') then
drop index [%QUALIFIER%]%TABLE%.%INDEX%
end if
Options 
in %s : category=tablespace
DefOptions 
in %s : category=tablespace
SqlListQuery —
SqlAttrQuery —
SqlOptsQuery In Sybase ASA 8: 

{OWNER, TABLE, INDEX, OPTIONS}

select 
   u.user_name,
   t.table_name,
   i.index_name,
   'in '+ f.dbspace_name 
from
   sys.sysuserperms u 
      join sys.systable t on (t.creator=u.user_id)
      join sys.sysindex i on (i.table_id=t.table_id)
      join sys.sysfile f on (f.file_id=i.file_id)
where i."unique" in ('Y', 'N')
[   and t.table_name=%.q:TABLE%]
[   and u.user_name=%.q:OWNER%]
SqlFragQuery In Oracle 9I: 

{VAR1NAME, VAR1VALUE}


select


   'Highval'||ip.partition_position,


   ip.high_value


from


   all_ind_partitions ip


where 1=1


[  and ip.index_owner=%.q:OWNER%]


[  and ip.index_name=%.q:INDEX%]
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
Add In Teradata V2R5: 

Create table (
%TABLDEFN%
)
[%INDEXDEFN%][%OPTIONS%]

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

 

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