Is there a way to add column comments in the same command as create table from Oracle?

Asked

Viewed 1,337 times

-2

There is a way to add column comments in the same command as the oracle create table, just as it is possible in Mysql?

CREATE TABLE user (
   id number COMMENT 'unique ID '
)

1 answer

2


You do this after create table.

Cannot place comments in the same create table command.

-- cria tabela
CREATE TABLE user (
   id number 
);
-- adiciona comentario
comment on column user.id
  is 'unique ID';

Documentação Comment

Documentation Create

Browser other questions tagged

You are not signed in. Login or sign up in order to post.