Connor at 13:35, 17 July 2012

2012-07-17T13:35:36Z

Connor at 13:12, 17 July 2012

2012-07-17T13:12:03Z

Connor: Created page with "Read tables from another schema/database

schema:gisq

A particular server may support a number of different sets of tables. In Or..."

2012-07-17T13:10:06Z

Created page with "Read tables from another schema/database <div class='ht'> <div class=params>schema:gisq</div> <div> A particular server may support a number of different sets of tables. In Or..."

New page

Read tables from another schema/database
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
A particular server may support a number of different sets of tables. In Oracle these are schemas in MySQL they are databases. In both cases each user normally has their own set of tables, other users tables may be accessed using a dot notation.
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-sqlite'></source>
<source lang='sql' class='def e-db2'></source>
<source lang='sql' class='def e-ingres'></source>
<source lang='sql' class='def e-access'>Access does not do this kind of thing.
</source>
<source lang='sql' class='def e-postgres'>not supported
</source>
<source lang='sql' class='def e-oracle'>SELECT COUNT(*) FROM haggis.tat
<source lang='sql' class='def e-sqlserver'>SELECT * FROM onedb.dbo.table1
</source>
<source lang='sql' class='def e-mysql'>SELECT * FROM scott.one
</source>
<source lang='sql' class='def e-mimer'></source>
<source lang='sql' class='def e-sybase'></source>

<div class="ecomm e-postgres" style="display: none">The current implementation of postgres does not allow this. However support will be included in release 7.3 as a new feature.
Thanks to Derek Barrett for this advice.</div>
<div class="ecomm e-oracle" style="display: none">haggis is another user with a table called tat.</div>
<div class="ecomm e-sqlserver" style="display: none">To connect to a table called table on a database called onedb, you need to know the owner of the schema for which that database is defined. Most tables default to schema owner dbo. So, you would type: select * from onedb.dbo.table If you have more than one MS server installed, add the server to the beginning of the string: select * from server1.onedb.dbo.table </div>
</div>
{{Users ref}}

@@ Line 16: / Line 16: @@
 </source>
 <source lang='sql' class='def e-oracle'>SELECT COUNT(*) FROM haggis.tat
 <source lang='sql' class='def e-sqlserver'>SELECT * FROM onedb.dbo.table1
 </source>

@@ Line 18: / Line 18: @@
 <source lang='sql' class='def e-sqlserver'>SELECT * FROM onedb.dbo.table1
 </source>
-<source lang='sql' class='def e-mysql'>SELECT * FROM scott.one
+<source lang='sql' class='def e-mysql'>SELECT * FROM gisq.one
 </source>
 <source lang='sql' class='def e-mimer'></source>

Read tables from another schema/database - Revision history

Connor at 13:35, 17 July 2012

Connor at 13:12, 17 July 2012

Connor: Created page with "Read tables from another schema/database schema:gisq A particular server may support a number of different sets of tables. In Or..."

Connor: Created page with "Read tables from another schema/database

schema:gisq

A particular server may support a number of different sets of tables. In Or..."