4.创建数据库表

来源:互联网 发布:制作ppt的软件 编辑:程序博客网 时间:2024/06/08 05:23

语法:

CREATE TABLE table_name

(col_name1 type1 [NOT NULL| NULL]

[{, col_name2 type2 [NOT NULL| NULL]} ...])

A database object (in this case, a table) is always created within a schema of a database. A user can create a table only in a schema for which she has ALTER permissions.