alter table Sql 表格處理
第一，我們要加入一個叫做 "Gender" 的欄位。這可以用以下的指令達成：
ALTER TABLE Customer ADD Gender char(1);
接下來，我們要把 "Address" 欄位改名為 "Addr"。這可以用以下的指令達成：
ALTER TABLE Customer CHANGE Address Addr char(50);
再來，我們要將 "Addr" 欄位的資料種類改為 char(30)。這可以用以下的指令達成：
ALTER TABLE Customer MODIFY Addr char(30);
最後，我們要刪除 "Gender" 欄位。這可以用以下的指令達成：
ALTER TABLE Customer DROP Gender;
來自:https://www.1keydata.com/tw/sql/sql-alter-table.html
迴響
alter table Sql 表格處理 | 豬窩
Thanks for every other great article. Where else may just anybody
get that kind of information in such a perfect way of writing?
I've a presentation subsequent week, and I'm on the search for such information.
alter table Sql 表格處理 | 豬窩
Hello mates, its wonderful post on the topic of teachingand fully defined, keep it up all
the time.
alter table Sql 表格處理 | 豬窩
Superb post however , I was wondering if you could write a litte more on this topic?
I'd be very grateful if you could elaborate a little bit further.
Appreciate it!