This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:attach:databases [2012/02/29 22:54] doc |
admin:features:attach:databases [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 23: | Line 23: | ||
<code> | <code> | ||
- | attach database GEO | + | > connect to simple |
- | from geo.xml; | + | Connected to D:\class\labs\attach\simple.xml |
+ | |||
+ | > attach database GEO | ||
+ | >> from geo.xml; | ||
+ | Database GEO attached | ||
+ | </code> | ||
+ | |||
+ | The newly attached database can be see using the SHOW TABLES command in OdxSQL: | ||
+ | |||
+ | <code> | ||
+ | > show tables | ||
+ | |||
+ | Tables | ||
+ | ------ | ||
+ | |||
+ | Environment | ||
+ | Database | ||
+ | Table Length Cols Rows Type | ||
+ | ---------------------------------------------------------------------------- | ||
+ | USER_ENVIRONMENT | ||
+ | SIMPLE | ||
+ | COUNTRIES 98 7 239 FIXED | ||
+ | STATES 44 6 76 FIXED | ||
+ | GENDERS 33 2 2 FIXED | ||
+ | HOUSEHOLDS 99 6 1,909 FIXED | ||
+ | INDIVIDUALS 159 7 5,000 FIXED | ||
+ | $TEMPDB | ||
+ | GEO | ||
+ | COUNTRIES 98 7 239 FIXED | ||
+ | REGIONS 36 4 12 FIXED | ||
+ | STATES 44 6 76 FIXED | ||
+ | COUNTIES 50 9 3,241 FIXED | ||
+ | ZIPCODES 76 11 42,474 FIXED | ||
</code> | </code> | ||