Guidelines
? The column may or may not contain data.
? Using the ALTER TABLE statement, only one column can be dropped at a time.(此句是否有误,做过实验,Alter Table 可以同时Drop多列啊)
? The table must have at least one column remaining in it after it is altered.
? Once a column is dropped, it cannot be recovered.
007的原文如上:
此句是否有误,做过实验,Alter Table 可以同时Drop多列啊)
最初由 dwilson 发布
[B]你的数据库版本多少? [/B]
SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 6月 10 15:54:50 2004
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
原文的版本为:
Oracle 9i student guide
40049GC10
Production 1.0
June 2001
D33051