创建表
CREATE TABLE students
(
stuid INT ,
stuname VARCHAR(50),
stusex CHAR(6),
stuage INT ,
stuclass VARCHAR(100),
stutel LONG
)修改表字段类型
alter table students modify (stuid number)
统计表中元组数目
select count(1) from userinfo
删除视图
drop view stus_stucard