SDB101 » Creating Tables
 
Table definition
  • "CREATE TABLE" statement
  • Specifies table name, attribute names and data types
  • Create a table with no rows
    • CREATE TABLE River(
      Name varchar(30),
      Origin varchar(30),
      Length number,
      Shape LineString );
Related statements
  • ALTER TABLE statement modifies table schema if needed
  • DROP TABLE statement removes an empty table

Última modificación: Thursday, 17 de November de 2005, 16:54