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:57] 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> | ||
| - | -> connect to simple | + | > connect to simple |
| Connected to D:\class\labs\attach\simple.xml | Connected to D:\class\labs\attach\simple.xml | ||
| - | -> | + | |
| - | -> attach table "AREACODES" | + | > attach table "AREACODES" |
| >> physical "dat/arc.dat" | >> physical "dat/arc.dat" | ||
| >> ( | >> ( | ||
| Line 63: | Line 63: | ||
| >> ); | >> ); | ||
| Table AREACODES attached | Table AREACODES attached | ||
| - | -> ; | + | </code> |
| - | -> show tables | + | |
| + | The newly attached tables can be seen using the SHOW TABLES command in OdxSQL: | ||
| + | |||
| + | <code> | ||
| + | > show tables | ||
| Tables | Tables | ||