Re: Erwin: setting a property for all tables



Don't use the GUI tool, instead use sqlplus and issue the following
query:

select 'alter table ' || table_name || ' xxxxxxx;' from user_tables;

where xxxx is the attribute of the table u want to modify.

Or something like this.
.



Relevant Pages

  • Re: Programmatically changing the field formats for a table
    ... You can modify some properties of a field with SQL statements, ... Roger dot Carlson at Spectrum-Health dot Org ... > created using a query. ... > the resulting table does not keep the field formats of the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: webbased search through catalog
    ... I've got the asp script working, but it seems to spit out results ... Modify q.catalog to specify your catalog name. ... > ' your logo is not a GIF file, or you don't want to copy it, change the ... > ' You can set the number of query results returned on a single page ...
    (microsoft.public.inetserver.indexserver)
  • Re: Changing query at runtime
    ... Thanks Joan, I already tried that, but after giving the qtemp object Read ... Design, Modify Design and even Admin permissions, I still get the "You do ... option" clause in the query. ... and give users modify permissions to the query. ...
    (microsoft.public.access.security)
  • Re: Fix transfer text automation
    ... you have to open a query based on this ... > I think the specs list is maintained in table MSysIMEXSpecs ... But I was hoping to modify the existing code. ... >>> Alex Dybenko (MVP) ...
    (microsoft.public.access.modulesdaovba)
  • Re: Albert D. Kallal -WordMerge20
    ... So I'd like the user to select the query from the ... date and the chosen WordMerge template. ... therefore DateParam (my user input form won't open). ... I'm wondering if there is a way to modify your WhatQuery form to accept user ...
    (microsoft.public.access.queries)