Difference between revisions of "Spatial Manager Desktop™ - FAQs: Databases"

From Spatial Manager Wiki
Jump to navigation Jump to search
m
m
Line 24: Line 24:
  
 
===Are there any other functions for the Tables in Spatial Manager Desktop™?===
 
===Are there any other functions for the Tables in Spatial Manager Desktop™?===
Yes, you can Delete or Rename the Tables in Spatial Manager Desktop™
+
Yes, you can Delete or Rename the Tables in Spatial Manager Desktop™ using the right-click menu over the Table item itself
  
  
Line 40: Line 40:
  
 
===Are there any other functions for the Schemas in Spatial Manager Desktop™?===
 
===Are there any other functions for the Schemas in Spatial Manager Desktop™?===
Yes, you can Delete or Rename the Schemas in Spatial Manager Desktop™. '''Be careful''' when you Delete a Schema because all the Tables that it contains will also be deleted
+
Yes, you can Delete or Rename the Schemas in Spatial Manager Desktop™ using the right-click menu over the Schema item itself. '''Be careful''' when you Delete a Schema because all the Tables that it contains will also be deleted
  
  

Revision as of 12:42, 26 February 2014

Introduction

  • Objective of this section
    • To load spatial information tables included in spatial databases
  • Topics in this section
    • Accessing spatial databases: UDSs definition using connection and setting parameters
    • Schemas and classes: structures of tables contained in databases
    • Other connections like ODBC, etc.


How can I load a data Table from a spatial database or data store into a Map in Spatial Manager Desktop™?

To access spatial databases or data stores you need first to have defined a User Data Source (UDS) including all the parameters to connect with (to learn more about UDSs, see: Data sources page)

You can load a data Table from a spatial database or data store using the right-click menu over the Table item itself inside a container of the UDS (usually a Schema), in the "Data sources" panel, to load its content into a new or existing Map. You can also double-click over the Table item itself, in the "Data sources" panel, to load its content into a new or existing Map (this behaviour may be configured in the application settings)


DB-1.png


Files-3.png


Are there any other functions for the Tables in Spatial Manager Desktop™?

Yes, you can Delete or Rename the Tables in Spatial Manager Desktop™ using the right-click menu over the Table item itself


DB-2.png


How can I create a Schema in a database in Spatial Manager Desktop™?

You can create a Schema in a database in Spatial Manager Desktop™ using the right-click menu over the UDS. When creating, you can assign a name to the New Schema


DB-3.png


Are there any other functions for the Schemas in Spatial Manager Desktop™?

Yes, you can Delete or Rename the Schemas in Spatial Manager Desktop™ using the right-click menu over the Schema item itself. Be careful when you Delete a Schema because all the Tables that it contains will also be deleted


DB-4.png


Related links