Hi,

Easy one : I want to change the name of the table that is the source of a drawing from a SQL query. What is the syntax ? I cannot find it.

Is there a list of properties in the documentation ? I cannot find it. The documentation is large, but I find it is often very hard to find what I want. M8 doc what so good. I miss it.

I tried with this, with no luck :

ALTER Drawing [base drawing]

(Drop Property ‘Table'

Add Property ‘Table' [base]

);

Thank you !

As long as you can't drop the Table property of the drawing you can replace the value of the property in the mfd_meta Table using an UPDATE.

Just take care of the fact the geom field in the new target table requires an index

best

a.

Merci apo.

This is working :

--SQL 

Update [mfd_meta]

Set 

 [Value] = '[Drawing newTable]' where [Name] = 'Drawing Name' and [Property] = 'Table';