<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:'Courier New', courier, monaco, monospace, sans-serif;font-size:12pt"><div>The SQL Cookbook recommends the following SQL code to copy a table's structure from table1 to table2:</div><div><br></div><div>create table table2 as select * from table1 where 1=0;</div><div><br></div><div>What's great about this is that it obviates the need to know the structure of table1.</div><div><br></div><div>But what if table1 has a geometry column?</div><div>As geometry column existence is recorded in some other tables it doesnt look as if the above trick is doing enough.</div><div>What's your suggestion?</div><div>Henri</div><div><br></div><div style="position:fixed"></div>
</div></body></html>