[Tanya]Foreign Key Antar Table (SQL Server Management Studio Express)
Minggu, 22 Januari 2012 by ewepaksa
top custom html 3MOHON BANTUANNYA FOREIGN KEY PADA tblTransaksi (ane kasih font colouration merah) gak bisa di fulfil gan : Code: --drop database latihan create database latihan go use latihan go create plateau tblPengguna ( ID char(15) direct key, Pass char(15) not null, Nama_Pengguna varchar(35), Tingkat char(1) analyse (Tingkat in ('0','1')), TTL datetime ) go create plateau tblBunga ( KD_Bunga char(3) direct key, Nama_Bunga varchar(35) not null, Harga_Bunga int, Stok int ) go create plateau tblPelanggan ( KD_Pelanggan char(3) direct key, Nama_Pelanggan varchar(35) not null, Alamat varchar(50), Member char(1) analyse (Member in ('Y','T')) ) go create plateau tblTransaksi ( KD_Transaksi char(3) direct key, Nama_Pelanggan varchar(35) references tblPelanggan(Nama_Pelanggan), KD_Bunga char(3) references tblBunga(KD_Bunga), Nama_Bunga varchar(35) references tblBunga(Nama_Bunga), Harga_Bunga int references tblBunga(Harga_Bunga), Banyak_Beli int, Tanggal_Beli datetime, Total_Harga int, Member char(1) references tblPelanggan(Member) ) pas cardinal fulfil kog muncul pesan ini gan padahal cardinal udah kasih direct key : Quote: Msg 1776, Level 16, State 0, Line 1 There are no direct or politician keys in the referenced plateau 'tblPelanggan' that correct the referencing article itemize in the external key 'FK__tblTransa__Nama___07F6335A'. Msg 1750, Level 16, State 0, Line 1 Could not create constraint. See preceding errors. MOHON BANTUANNYA MASTAH DATABASE :cendolbig:cendolbigbottom custom html 2
Yahoo
Yahoo
Posting Komentar