Create a table with a geospatial column

Edit online

The geospatial data types can be used to create columns for storing geospatial data.

Use the CREATE TABLE SQL statement to create a table with a geospatial column that represents the location of the business.


CREATE TABLE BRANCHES
  (ID INT,
   NAME VARCHAR(30),
   ADDRESS VARCHAR(100),
   CITY VARCHAR(50),
   POSTAL_CODE VARCHAR(5),
   STATE CHAR(2),
   COUNTRY VARCHAR(20),
   LOCATION QSYS2.ST_POINT);