DB2如何删除用户ZHX的所有表:
db2 -x "select 'drop table '||tabschema||'.'||tabname||';'from syscat.tables where tabschema ='ZHX'" > drop.sql
db2 -tf drop.sql
Oracle 锁表的SQL语句: lock table subjectfilterlist in exclusive mode; 执行后不提交,表就被锁住了。提交后又解锁了。
ORACLE:
drop table "www" cascade constraints;
CREATE TABLE WWW (
SRVNAME VARCHAR2(32) NOT NULL,
SRVIP VARCHAR2(16) NOT NULL,
CONSTRAINT PK_www PRIMARY KEY (SRVNAME)
);
ALTER TABLE WWW ADD CONSTRAINT uq_www_ip UNIQUE(SRVIP);
执行SQL文件:/home/wzj/mms_home/db/dbscript>cat portal_1_role.sql | sql
sqlplus运行sql文件: sql>@C:\Database\my.sql