This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:attach:tables [2012/02/29 22:58] doc |
admin:features:attach:tables [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 30: | Line 30: | ||
- | Attaching a table is simple, and uses syntax that is nearly identical to CREATE TABLE, as shown below: | + | Attaching a table is simple, and uses the [[dev:sql:statements:attach_table:home|ATTACH TABLE]] statement. The ATTACH TABLE syntax is nearly identical to CREATE TABLE, as shown below: |
<code> | <code> | ||
Line 63: | Line 63: | ||
>> ); | >> ); | ||
Table AREACODES attached | Table AREACODES attached | ||
+ | </code> | ||
+ | The newly attached tables can be seen using the SHOW TABLES command in OdxSQL: | ||
+ | |||
+ | <code> | ||
> show tables | > show tables | ||