Chapter 3 DBMS Reference Guide

Common entries for Default

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

Entry Example (Sybase ASE 12.5)
Enable Enable = Yes
SqlListQuery 
{DEFAULT ID, SCRIPT ...}
select
   convert(char(20), d.tdefault),
   t.text
from
   [%CATALOG%.]dbo.systypes d,
   [%CATALOG%.]dbo.syscomments t
where
   t.id = d.tdefault
   and (t.texttype=0 or t.texttype=2)
[  and d.name = %.q:DOMAIN%]
order by
   1, 2
Drop 
drop default [%QUALIFIER%]%DEFAULT%
Create 
create default [%QUALIFIER%]%DEFAULT%


    as %VALUE%


The default create statement

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

 

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