ITPub博客

首页 > 应用开发 > IT综合 > CREAT TABLE用法

CREAT TABLE用法

原创 IT综合 作者:kvsion 时间:2010-05-03 21:51:39 0 删除 编辑
CREATE TABLE[@more@]

To create a relational table in your own schema, you must have the CREATE TABLE system privilege. To create a table in another user's schema, you must have the CREATE ANY TABLE system privilege. Also, the owner of the schema to contain the table must have either space quota on the tablespace to contain the table or the UNLIMITED TABLESPACE system privilege.

CREATE RELATIONAL TABLE:

CREATE TABLE SCHEMA.TABLE_NAME (relational_properties) [physical_properties] [table_properties]

column definition:

column_name datatype default expr inline_constraints

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11269677/viewspace-1033353/,如需转载,请注明出处,否则将追究法律责任。

上一篇: TRUNC函数用法
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2008-09-20

  • 博文量
    17
  • 访问量
    23801