SQL清除语句

来源:百度知道 编辑:UC知道 时间:2024/06/14 18:43:46
我想清除SQL空间所有的数据,请问执行什么语句?本人新手,请职教,在线等.
支持环境:
ASP/asp.net 1.1/php/
支持数据库:
ACCESS SQL2000 MySQL4.1

是phpMyAdmin 2.6.0

楼下几位说的我还是不懂哦,不好意思

CREATE SNAPSHOT [schema.]snapshot
[ [PCTFREE integer] [PCTUSED integer]
[INITRANS integer] [MAXTRANS integer]
[TABLESPACE tablespace]
[STORAGE storage_clause]

[ USING INDEX [ PCTFREE integer | TABLESPACE tablespace
| INITTRANS integer | MAXTRANS integer
| STORAGE storage_clause ] ...
| [CLUSTER cluster (column [, column]...)] ]
[ REFRESH [FAST | COMPLETE | FORCE] [START WITH date] [NEXT date]]
AS subquery

schema
is the schema to contain the snapshot. If you omit schema, Oracle

creates the snapshot in your sc