Oracle中 Alter Table 语句的使用
alter table 的功能是修改表格。包括重名命，加减字段,修改字段类型和大小，处理 约束等等。本例子之处理表名和字段，代码如下：<div style="padding-right: 5.4pt; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 4px; width: 95%; padding-top: 4px;">http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifcreatetableliu(avarchar2(20),bnumber(2))
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifaltertableliurenametojin
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifrenamejintocai
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifaltertablecaiaddcvarchar2(30)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifaltertablecaiadd(dvarchar2(30),enumber(4))
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifaltertablecairenamecolumnetof
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifaltertablecaimodifydvarchar(40)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifaltertablecaimodifyfvarchar(40)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifaltertablecaidropcolumnf
页:
[1]