create table/type

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Hicham G. Elmongui

    #1

    create table/type

    is there a way to create a table with a certain type?

    CREATE TYPE typename AS (id integer, name varchar);

    and something like

    CREATE TABLE names OF TYPE typename.


    Is there a syntax to support this?

    thanks,
    --h


Working...