{"id":10300,"date":"2026-11-11T12:21:38","date_gmt":"2026-11-11T09:21:38","guid":{"rendered":"https:\/\/www.yunuskaytan.com\/?p=10300"},"modified":"2026-11-11T12:21:38","modified_gmt":"2026-11-11T09:21:38","slug":"sql-de-birincil-ve-yabanci-anahtar","status":"publish","type":"post","link":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-de-birincil-ve-yabanci-anahtar\/?lang=en","title":{"rendered":"SQL&#8217;de Birincil ve Yabanc\u0131 Anahtar"},"content":{"rendered":"<p class=\"wp-block-paragraph\">\u0130li\u015fkisel veritaban\u0131 y\u00f6netim sistemlerinin (RDBMS) temel \u00e7al\u0131\u015fma mant\u0131\u011f\u0131, verilerin mant\u0131ksal tablolara b\u00f6l\u00fcnmesi ve bu tablolar\u0131n belirli kurallar \u00e7er\u00e7evesinde birbiriyle haberle\u015fmesi \u00fczerine kuruludur. B\u00fcy\u00fck \u00f6l\u00e7ekli yaz\u0131l\u0131mlarda y\u00fczlerce tablonun ve milyonlarca sat\u0131r verinin bulundu\u011fu senaryolarda, her bir verinin tekil olarak ay\u0131rt edilmesi ve tablolar aras\u0131ndaki ili\u015fkilerin kopmamas\u0131 hayati bir \u00f6neme sahiptir. Veritaban\u0131 mimarisinde bu d\u00fczeni sa\u011flayan en temel iki yap\u0131 ta\u015f\u0131; birincil anahtar (Primary Key) ve yabanc\u0131 anahtar (Foreign Key) k\u0131s\u0131tlamalar\u0131d\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Birincil Anahtar (Primary Key) Nedir?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Birincil anahtar, bir veritaban\u0131 tablosundaki her sat\u0131r\u0131 benzersiz bir \u015fekilde tan\u0131mlayan k\u0131s\u0131tlamad\u0131r (constraint). Bir tabloda kimlik numaras\u0131, kullan\u0131c\u0131 kimli\u011fi veya sipari\u015f numaras\u0131 gibi her kay\u0131tta farkl\u0131 olan s\u00fctunlar bu ama\u00e7la kullan\u0131l\u0131r. SQL mimarisinde birincil anahtar tan\u0131mland\u0131\u011f\u0131nda, veritaban\u0131 motoru ilgili s\u00fctun \u00fczerinde otomatik olarak benzersiz bir indeks (unique index) olu\u015fturur ve veri arama i\u015flemlerinin y\u00fcksek performansla ger\u00e7ekle\u015fmesini sa\u011flar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Veritaban\u0131 tasar\u0131m\u0131nda sql primary key kullan\u0131m\u0131 veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fcn ilk ad\u0131m\u0131d\u0131r. Birincil anahtar olmadan bir tabloda birbirinin tamamen kopyas\u0131 olan sat\u0131rlar birikebilir ve bu durum sorgulama, g\u00fcncelleme veya silme i\u015flemlerinde ciddi veri karma\u015fas\u0131na yol a\u00e7ar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Birincil Anahtar\u0131n Temel \u00d6zellikleri<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Benzersizlik (Uniqueness): S\u00fctundaki her bir de\u011fer yaln\u0131zca bir kez bulunabilir, m\u00fckerrer kayda izin verilmez.<\/li>\n\n<li>Bo\u015f De\u011fer \u0130\u00e7ermeme (Not Null): Birincil anahtar s\u00fctununda yer alan alanlar kesinlikle bo\u015f (NULL) b\u0131rak\u0131lamaz.<\/li>\n\n<li>Tek Tabloda Tek Anahtar: Bir tabloda yaln\u0131zca bir adet birincil anahtar bulunabilir; ancak bu anahtar birden fazla s\u00fctunun birle\u015fiminden (Composite Key) olu\u015fabilir.<\/li>\n\n<li>De\u011fi\u015fmezlik: Birincil anahtar olarak se\u00e7ilen verinin zaman i\u00e7inde g\u00fcncellenmeyecek veya nadiren g\u00fcncellenecek bir de\u011fer olmas\u0131 tercih edilir.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">SQL ile Birincil Anahtar Tan\u0131mlama<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Birincil anahtar iki farkl\u0131 y\u00f6ntemle tan\u0131mlanabilir: Tablo olu\u015fturulurken veya mevcut bir tabloya sonradan k\u0131s\u0131tlama eklenerek. A\u015fa\u011f\u0131daki \u00f6rnekte, yeni bir kullan\u0131c\u0131lar tablosu olu\u015fturulurken kimlik s\u00fctununa birincil anahtar kural\u0131 tan\u0131mlanmaktad\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Kullanicilar (\n    KullaniciID INT NOT NULL,\n    Ad VARCHAR(50) NOT NULL,\n    Soyad VARCHAR(50) NOT NULL,\n    Eposta VARCHAR(100) NOT NULL,\n    PRIMARY KEY (KullaniciID)\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu komutta <code>KullaniciID<\/code> s\u00fctunu <code>INT<\/code> veri tipiyle tan\u0131mlanm\u0131\u015f ve tablonun sonunda <code>PRIMARY KEY (KullaniciID)<\/code> ifadesiyle birincil anahtar olarak belirlenmi\u015ftir. Bu sayede veritaban\u0131, ayn\u0131 <code>KullaniciID<\/code> de\u011ferine sahip ikinci bir sat\u0131r\u0131n eklenmesini do\u011frudan engelleyecektir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Halihaz\u0131rda var olan bir tabloya sonradan birincil anahtar eklemek gerekti\u011finde <code>ALTER TABLE<\/code> komutu kullan\u0131l\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE Kullanicilar\nADD PRIMARY KEY (KullaniciID);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu i\u015flemin ba\u015far\u0131l\u0131 olabilmesi i\u00e7in <code>KullaniciID<\/code> s\u00fctununda \u00f6nceden tan\u0131mlanm\u0131\u015f bo\u015f (NULL) veya yinelenen de\u011fer bulunmamas\u0131 zorunludur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Yabanc\u0131 Anahtar (Foreign Key) Nedir?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Yabanc\u0131 anahtar, bir tablodaki s\u00fctunun ba\u015fka bir tablodaki birincil anahtara (veya benzersiz anahtara) referans vermesini sa\u011flayan yap\u0131d\u0131r. Bu sayede iki tablo aras\u0131nda mant\u0131ksal ve kurall\u0131 bir ili\u015fki kurulur. Yabanc\u0131 anahtar\u0131n bulundu\u011fu tabloya &#8220;\u00e7ocuk tablo&#8221; (child table), referans al\u0131nan tabloya ise &#8220;ana tablo&#8221; (parent table) ad\u0131 verilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yabanc\u0131 anahtarlar\u0131n en temel i\u015flevi referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc (referential integrity) korumakt\u0131r. Ba\u015fka bir deyi\u015fle, sistemde kay\u0131tl\u0131 olmayan bir kullan\u0131c\u0131ya sipari\u015f atanmas\u0131n\u0131 veya mevcut bir kullan\u0131c\u0131n\u0131n silindi\u011finde ona ait sipari\u015flerin havada (yetim kay\u0131t \/ orphan record) kalmas\u0131n\u0131 engeller.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Yabanc\u0131 Anahtar\u0131n Kurallar\u0131 ve Davran\u0131\u015flar\u0131<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>De\u011fer E\u015fle\u015fmesi: \u00c7ocuk tablodaki yabanc\u0131 anahtar de\u011feri, mutlaka ana tablodaki birincil anahtar de\u011ferlerinden biriyle e\u015fle\u015fmelidir.<\/li>\n\n<li>Bo\u015f De\u011fer \u0130stisnas\u0131: Birincil anahtar\u0131n aksine, yabanc\u0131 anahtar s\u00fctunu aksi belirtilmedik\u00e7e NULL de\u011fer kabul edebilir.<\/li>\n\n<li>\u0130li\u015fkisel Eylemler: Ana tablodaki bir kay\u0131t silindi\u011finde veya g\u00fcncellendi\u011finde, \u00e7ocuk tablodaki ba\u011fl\u0131 kay\u0131tlar\u0131n nas\u0131l davranaca\u011f\u0131 belirlenebilir:<\/li>\n\n<li>CASCADE: Ana tablodaki kay\u0131t silinirse veya g\u00fcncellenirse, ba\u011fl\u0131 t\u00fcm \u00e7ocuk kay\u0131tlar da otomatik olarak silinir veya g\u00fcncellenir.<\/li>\n\n<li>SET NULL: Ana tablodaki kay\u0131t silindi\u011finde, ba\u011fl\u0131 \u00e7ocuk tablodaki yabanc\u0131 anahtar alan\u0131 NULL yap\u0131l\u0131r.<\/li>\n\n<li>RESTRICT veya NO ACTION: Ba\u011fl\u0131 alt kay\u0131tlar varken ana tablodaki kayd\u0131n silinmesini veya de\u011fi\u015ftirilmesini engeller.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">SQL ile Yabanc\u0131 Anahtar Tan\u0131mlama<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Kullan\u0131c\u0131lar\u0131n sipari\u015flerini tutan bir tablo olu\u015fturuldu\u011funda, her sipari\u015fin hangi kullan\u0131c\u0131ya ait oldu\u011funu belirtmek i\u00e7in yabanc\u0131 anahtar kullan\u0131l\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE Siparisler (\n    SiparisID INT NOT NULL,\n    SiparisTarihi DATE NOT NULL,\n    KullaniciID INT,\n    Tutar DECIMAL(10, 2),\n    PRIMARY KEY (SiparisID),\n    FOREIGN KEY (KullaniciID) REFERENCES Kullanicilar(KullaniciID)\n    ON DELETE CASCADE\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu \u00f6rnekte <code>Siparisler<\/code> tablosunda <code>SiparisID<\/code> birincil anahtar, <code>KullaniciID<\/code> ise <code>Kullanicilar<\/code> tablosuna ba\u011flanan yabanc\u0131 anahtard\u0131r. Komutun sonuna eklenen <code>ON DELETE CASCADE<\/code> ifadesi, <code>Kullanicilar<\/code> tablosundan bir kullan\u0131c\u0131 silindi\u011finde, o kullan\u0131c\u0131ya ait t\u00fcm sipari\u015f kay\u0131tlar\u0131n\u0131n da otomatik olarak silinmesini sa\u011flar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mevcut bir tabloya yabanc\u0131 anahtar k\u0131s\u0131tlamas\u0131 sonradan \u015fu \u015fekilde eklenebilir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE Siparisler\nADD CONSTRAINT FK_KullaniciSiparis\nFOREIGN KEY (KullaniciID) REFERENCES Kullanicilar(KullaniciID);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu komut ile <code>FK_KullaniciSiparis<\/code> ad\u0131nda bir k\u0131s\u0131tlama tan\u0131mlan\u0131r. K\u0131s\u0131tlamalara isim vermek, ilerleyen s\u00fcre\u00e7lerde k\u0131s\u0131tlamay\u0131 kald\u0131rmak veya de\u011fi\u015ftirmek gerekti\u011finde kolayl\u0131k sa\u011flar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Birincil ve Yabanc\u0131 Anahtar Aras\u0131ndaki Temel Farklar<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tan\u0131mlay\u0131c\u0131l\u0131k: Birincil anahtar bulundu\u011fu tablodaki sat\u0131rlar\u0131 tekil yapar; yabanc\u0131 anahtar ise ba\u015fka bir tablodaki tekil sat\u0131ra i\u015faret eder.<\/li>\n\n<li>NULL Kabul\u00fc: Birincil anahtar s\u00fctunlar\u0131 NULL de\u011fer alamaz; yabanc\u0131 anahtar s\u00fctunlar\u0131 kurguya g\u00f6re NULL de\u011fer alabilir.<\/li>\n\n<li>Tablodaki Say\u0131: Bir tabloda sadece bir birincil anahtar bulunabilir; fakat bir tablo birden fazla tabloya ba\u011flanarak birden \u00e7ok yabanc\u0131 anahtar bar\u0131nd\u0131rabilir.<\/li>\n\n<li>\u0130ndeksleme: SQL veritabanlar\u0131nda birincil anahtarlar varsay\u0131lan olarak Clustered Index \u015feklinde otomatik indekslenir; yabanc\u0131 anahtarlar\u0131n sorgu performans\u0131n\u0131 art\u0131rmak i\u00e7in \u00e7o\u011funlukla elle indekslenmesi gerekir.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Veri B\u00fct\u00fcnl\u00fc\u011f\u00fc ve G\u00fcvenlik A\u00e7\u0131s\u0131ndan \u00d6nemi<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Veritaban\u0131 g\u00fcvenli\u011fi yaln\u0131zca yetkilendirme ve \u015fifreleme mekanizmalar\u0131ndan ibaret de\u011fildir. Verinin do\u011frulu\u011fu, bozulmam\u0131\u015f olmas\u0131 ve mant\u0131ksal b\u00fct\u00fcnl\u00fc\u011f\u00fc de siber g\u00fcvenlik ve yaz\u0131l\u0131m kararl\u0131l\u0131\u011f\u0131 kapsam\u0131nda ele al\u0131n\u0131r. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Eksik kurgulanm\u0131\u015f bir veritaban\u0131nda meydana gelebilecek tutars\u0131zl\u0131klar; faturaland\u0131rma hatalar\u0131na, yetkisiz veri s\u0131z\u0131nt\u0131lar\u0131na veya yaz\u0131l\u0131m taraf\u0131nda beklenmeyen \u00e7\u00f6kmelere yol a\u00e7abilir. Birincil ve yabanc\u0131 anahtar k\u0131s\u0131tlamalar\u0131, uygulama katman\u0131nda olu\u015fabilecek kodlama hatalar\u0131na kar\u015f\u0131 veritaban\u0131 seviyesinde son savunma hatt\u0131 olarak g\u00f6rev yapar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00d6zet ve Sonraki Ad\u0131mlar<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Birincil anahtar (sql primary key) tablodaki verilerin tekilli\u011fini garanti alt\u0131na al\u0131rken, yabanc\u0131 anahtar (foreign key) tablolar aras\u0131ndaki ili\u015fkileri koruyarak yetim veya ge\u00e7ersiz verilerin olu\u015fmas\u0131n\u0131 \u00f6nler. Sa\u011flam temellere sahip bir veritaban\u0131 tasarlamak i\u00e7in bu iki k\u0131s\u0131tlaman\u0131n do\u011fru planlanmas\u0131 \u015fartt\u0131r. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sonraki ad\u0131m olarak, tablolar aras\u0131 bu ili\u015fkileri sorgularda birle\u015ftirmeyi sa\u011flayan INNER JOIN, LEFT JOIN gibi birle\u015ftirme t\u00fcrlerini ve foreign key s\u00fctunlar\u0131 \u00fczerinde indeksleme yaparak sorgu performans\u0131n\u0131 art\u0131rma y\u00f6ntemlerini inceleyebilirsiniz.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u0130li\u015fkisel veritaban\u0131 y\u00f6netiminde veri tutarl\u0131l\u0131\u011f\u0131n\u0131 ve tablolar aras\u0131 ba\u011f\u0131 kuran birincil ve yabanc\u0131 anahtarlar\u0131n kullan\u0131m\u0131n\u0131 detaylar\u0131yla inceliyoruz.<\/p>","protected":false},"author":1,"featured_media":10301,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[230],"tags":[597,596,588,254,257],"class_list":["post-10300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani","tag-foreign-key","tag-primary-key","tag-rdbms","tag-sql","tag-veritabani"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL&#039;de Birincil ve Yabanc\u0131 Anahtar - Yunus KAYTAN<\/title>\n<meta name=\"description\" content=\"SQL primary key ve foreign key nedir, nas\u0131l kullan\u0131l\u0131r? \u0130li\u015fkisel veritabanlar\u0131nda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan anahtar kavramlar\u0131 \u00f6rneklerle \u00f6\u011frenin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-de-birincil-ve-yabanci-anahtar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL&#039;de Birincil ve Yabanc\u0131 Anahtar - Yunus KAYTAN\" \/>\n<meta property=\"og:description\" content=\"SQL primary key ve foreign key nedir, nas\u0131l kullan\u0131l\u0131r? \u0130li\u015fkisel veritabanlar\u0131nda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan anahtar kavramlar\u0131 \u00f6rneklerle \u00f6\u011frenin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-de-birincil-ve-yabanci-anahtar\/\" \/>\n<meta property=\"og:site_name\" content=\"Yunus KAYTAN\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-11T09:21:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yunuskaytan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yunuskaytan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/\"},\"author\":{\"name\":\"yunuskaytan\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/person\\\/be66986fb499da83a5685de34f68d15a\"},\"headline\":\"SQL&#8217;de Birincil ve Yabanc\u0131 Anahtar\",\"datePublished\":\"2026-11-11T09:21:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/\"},\"wordCount\":1136,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg\",\"keywords\":[\"foreign key\",\"primary key\",\"rdbms\",\"sql\",\"veritaban\u0131\"],\"articleSection\":[\"Veritaban\u0131\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/\",\"name\":\"SQL'de Birincil ve Yabanc\u0131 Anahtar - Yunus KAYTAN\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg\",\"datePublished\":\"2026-11-11T09:21:38+00:00\",\"description\":\"SQL primary key ve foreign key nedir, nas\u0131l kullan\u0131l\u0131r? \u0130li\u015fkisel veritabanlar\u0131nda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan anahtar kavramlar\u0131 \u00f6rneklerle \u00f6\u011frenin.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg\",\"width\":1200,\"height\":630,\"caption\":\"SQL'de Birincil ve Yabanc\u0131 Anahtar\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-de-birincil-ve-yabanci-anahtar\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL&#8217;de Birincil ve Yabanc\u0131 Anahtar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#website\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\",\"name\":\"Yunus KAYTAN\",\"description\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yunuskaytan.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\",\"name\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-BILISIM-VE-SIBER-GUVENLIK.png\",\"contentUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-BILISIM-VE-SIBER-GUVENLIK.png\",\"width\":400,\"height\":109,\"caption\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/person\\\/be66986fb499da83a5685de34f68d15a\",\"name\":\"yunuskaytan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"caption\":\"yunuskaytan\"},\"sameAs\":[\"http:\\\/\\\/www.yunuskaytan.com\"],\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/en\\\/yk\\\/author\\\/yunuskaytan\\\/?lang=en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL'de Birincil ve Yabanc\u0131 Anahtar - Yunus KAYTAN","description":"SQL primary key ve foreign key nedir, nas\u0131l kullan\u0131l\u0131r? \u0130li\u015fkisel veritabanlar\u0131nda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan anahtar kavramlar\u0131 \u00f6rneklerle \u00f6\u011frenin.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-de-birincil-ve-yabanci-anahtar\/","og_locale":"en_US","og_type":"article","og_title":"SQL'de Birincil ve Yabanc\u0131 Anahtar - Yunus KAYTAN","og_description":"SQL primary key ve foreign key nedir, nas\u0131l kullan\u0131l\u0131r? \u0130li\u015fkisel veritabanlar\u0131nda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan anahtar kavramlar\u0131 \u00f6rneklerle \u00f6\u011frenin.","og_url":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-de-birincil-ve-yabanci-anahtar\/","og_site_name":"Yunus KAYTAN","article_published_time":"2026-11-11T09:21:38+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg","type":"image\/jpeg"}],"author":"yunuskaytan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yunuskaytan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#article","isPartOf":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/"},"author":{"name":"yunuskaytan","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/person\/be66986fb499da83a5685de34f68d15a"},"headline":"SQL&#8217;de Birincil ve Yabanc\u0131 Anahtar","datePublished":"2026-11-11T09:21:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/"},"wordCount":1136,"commentCount":0,"publisher":{"@id":"https:\/\/www.yunuskaytan.com\/#organization"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg","keywords":["foreign key","primary key","rdbms","sql","veritaban\u0131"],"articleSection":["Veritaban\u0131"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/","url":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/","name":"SQL'de Birincil ve Yabanc\u0131 Anahtar - Yunus KAYTAN","isPartOf":{"@id":"https:\/\/www.yunuskaytan.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#primaryimage"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg","datePublished":"2026-11-11T09:21:38+00:00","description":"SQL primary key ve foreign key nedir, nas\u0131l kullan\u0131l\u0131r? \u0130li\u015fkisel veritabanlar\u0131nda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan anahtar kavramlar\u0131 \u00f6rneklerle \u00f6\u011frenin.","breadcrumb":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#primaryimage","url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg","contentUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-de-birincil-ve-yabanci-anahtar-kapak.jpg","width":1200,"height":630,"caption":"SQL'de Birincil ve Yabanc\u0131 Anahtar"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-de-birincil-ve-yabanci-anahtar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.yunuskaytan.com\/"},{"@type":"ListItem","position":2,"name":"SQL&#8217;de Birincil ve Yabanc\u0131 Anahtar"}]},{"@type":"WebSite","@id":"https:\/\/www.yunuskaytan.com\/#website","url":"https:\/\/www.yunuskaytan.com\/","name":"Yunus KAYTAN","description":"Information Technology, Cybersecurity, Cybercrimes and Social Engineering","publisher":{"@id":"https:\/\/www.yunuskaytan.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yunuskaytan.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.yunuskaytan.com\/#organization","name":"Information Technology, Cybersecurity, Cybercrimes and Social Engineering","url":"https:\/\/www.yunuskaytan.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/2021\/07\/cropped-BILISIM-VE-SIBER-GUVENLIK.png","contentUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/2021\/07\/cropped-BILISIM-VE-SIBER-GUVENLIK.png","width":400,"height":109,"caption":"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/person\/be66986fb499da83a5685de34f68d15a","name":"yunuskaytan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","caption":"yunuskaytan"},"sameAs":["http:\/\/www.yunuskaytan.com"],"url":"https:\/\/www.yunuskaytan.com\/en\/yk\/author\/yunuskaytan\/?lang=en"}]}},"_links":{"self":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/comments?post=10300"}],"version-history":[{"count":1,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10300\/revisions"}],"predecessor-version":[{"id":10304,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10300\/revisions\/10304"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/media\/10301"}],"wp:attachment":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/media?parent=10300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/categories?post=10300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/tags?post=10300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}