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> | ||