1、数据库
创建:
CREATE DATABASE database_name;
删除:
DROP DATABASE database_name;
2、表
创建:
CREATE TABLE table_name (
column1 datatype,
...
);
删除:
DROP TABLE table_name;
3、索引
创建:
CREATE INDEX index_name ON table_name (column_name);
删除:
DROP INDEX index_name ON table_name;
4、视图
创建:
CREATE VIEW view_name AS
SELECT ...
FROM table_name
WHERE ...;
删除:
DROP VIEW view_name;