MSSQL-2000 Server 有A.dbo (cno,cname,ctel....) Primary(cno) B.dbo (orno,ortype,cno,.... 其中A->CNO與B->CNO是relationship,在enterprise manager手動relationship 從書籍學到。 如果使用sql語法,而非使用enterprise manager手動relationship 如何使2個table關聯 謝謝

alter table B add constraint cno_fk foreign key(cno) references A(cno) a為主..

------
熊的學習 http://huwk.blogspot.com

引言: 謝謝指導,測式後有下列錯誤message /// Incorrect syntax near the keyword 'constraint' /// unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, Grids, DBGrids, DB, ADODB; type TForm1 = class(TForm) ADOQuery1: TADOQuery; DataSource1: TDataSource; DBGrid1: TDBGrid; ADOQuery2: TADOQuery; DataSource2: TDataSource; DBGrid2: TDBGrid; Button1: TButton; procedure Button1Click(Sender: TObject); private { Private declarations } public { Public declarations } end; var Form1: TForm1; implementation {$R *.dfm} procedure TForm1.Button1Click(Sender: TObject); begin ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('Alter Table Cust'); ADOQuery1.SQL.Add('constraint cust_index_1 foreign key(cno)'); ADOQuery1.SQL.Add('references Pro(cno)'); ADOQuery1.ExecSQL; end; end.

引言:

引言: create table sa (cno char(5) primary key,cname char(30),ctel char(13),caddr char(50) ) create table sb (qno char(5) primary key,qname char(30),qadd char(50),cno char(5) constraint fk_sb foreign key references sa(cno) ) try try see