Ok.. then back to my original question
Source Metadata can have a "native query" property set so is it possible to create a source table with a native query specified and do so via DDL?
> I'm sorry I guesss I assumed the "FOREIGN TABLE" designation was optional.
Foreign table means a source table.
> So am I to understand you cannot use DDL on ANYTHING physical ?
Teiid DDL can be used to specify both source and virtual metadata. Source metadata will have the FOREIGN keyword.