Subject | Re: [firebird-support] getting rid of column names |
---|---|
Author | Paulius Pazera |
Post date | 2004-03-09T18:41:57Z |
| any way to get rid of column name in
|
| select 'drop procedure ' || rdb$procedure_name || ';' from rdb$procedures
| where rdb$procedure_name like 'REP_%';
|
| so that we can run dynamic scripts as we used to in interbase?
Select cast("" as varchar(255)) from onerow
union all
select cast('drop procedure ' || rdb$procedure_name || ';' as varchar(255))
from rdb$procedures where rdb$procedure_name like 'REP_%'
|
| select 'drop procedure ' || rdb$procedure_name || ';' from rdb$procedures
| where rdb$procedure_name like 'REP_%';
|
| so that we can run dynamic scripts as we used to in interbase?
Select cast("" as varchar(255)) from onerow
union all
select cast('drop procedure ' || rdb$procedure_name || ';' as varchar(255))
from rdb$procedures where rdb$procedure_name like 'REP_%'