Re: How to select records from columns with where default =

Hi,

select * from sys.all_tab_columns where DATA_TYPE like 'DA%' and data_default like '9999%'


works perfectly here ...

Flo



Beermann, Albert schrieb:
> Hello Everbody !
> 
> With sql-studio i want to select some records from the columns table
> (date or datetime fields with  default definition)
> 
> I can do:
> 
> Select * from columns where datatype like 'DA%'
> 
> I want to do:
> 
> Select * from columns where datatype like 'DA%' and default like '9999%'
> 
> Error ! default no allowed
> 
>  
> 
> Any help welcomed.
> 
> Best regards 
> 
> Albert
> 
>                               ''''' 
>                              ''''''''' 
>                             (0 0) 
>  +---------oOO-----------(_)------------------------------+ 
>  | Tel: 0541/5841-868                                  | 
>  | Fax: 0541/5841-869                                 | 
>  | Mail: mailto:[email protected]
> <mailto:[email protected]>   |  
>  | Internet:  http://www.piepenbrock.de <http://www.piepenbrock.de/>
> | 
>  +--------------------------------------oOO----------------+ 
>                           |__|__| 
>                             ||  || 
>                         ooO Ooo 
> 
>  
> 
> 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]