tech_state板大您好,小弟參考您的 http://delphi.ktop.com.tw/topic.php?TOPIC_ID=32427 中的寫法,而小弟又想在column1中加入主索引...寫法如下.. // Add Fields ADOQuery2->Close(); ADOQuery2->SQL->Text = "alter table tb1 add column column1 char(10) "; ADOQuery2->ExecSQL(); ADOQuery2->SQL->Text = "alter table tb1 add index column1 (column1)"; ADOQuery2->ExecSQL(); ShowMessage("Add Fields OK"); delete ADOQuery2; 但不知為什麼都會有錯誤的訊息,可以請教您如何解決嗎? ps.小弟是參考http://www.kuix.de/links/sql.html中的寫法..不過小弟沒學過sql,所以不太懂... ALTER TABLE tbl_name alter_spec [, alter_spec ...] alter_specification: ADD [COLUMN] create_definition [FIRST | AFTER column_name ] or ADD [COLUMN] (create_definition, create_definition,...) or ADD INDEX [index_name] (index_col_name,...) or ADD PRIMARY KEY (index_col_name,...) or ADD UNIQUE [index_name] (index_col_name,...) or ALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT} or CHANGE [COLUMN] old_col_name create_definition or MODIFY [COLUMN] create_definition or DROP [COLUMN] col_name or DROP PRIMARY KEY or DROP INDEX index_name or RENAME [AS] new_tbl_name or table_options

找了好久... 終於找到答案嚕... // Add Fields ADOQuery2->Close(); ADOQuery2->SQL->Text = "alter table tb1 add column column1 char(10) "; ADOQuery2->ExecSQL(); ADOQuery2->SQL->Text = "alter table tb1 PRIMARY KEY (column1)"; ADOQuery2->ExecSQL(); ShowMessage("Add Fields OK"); delete ADOQuery2;