 | | | How to select records from columns with where default = | How to select records from columns with where default = 2007-01-08 - By Florian Schmitz
Back
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:a.beermann@(protected)
> <mailto:a.beermann@(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/maxdb?unsub=mysql@(protected)
|
|
|