{"id":128,"date":"2026-02-20T14:23:20","date_gmt":"2026-02-20T11:23:20","guid":{"rendered":"https:\/\/www.esraturan.com.tr\/index.php\/temel-sql-komutlari\/"},"modified":"2026-02-20T15:58:27","modified_gmt":"2026-02-20T12:58:27","slug":"temel-sql-komutlari","status":"publish","type":"page","link":"https:\/\/www.esraturan.com.tr\/index.php\/temel-sql-komutlari\/","title":{"rendered":"Temel SQL Komutlar\u0131"},"content":{"rendered":"\n

CREATE<\/mark><\/p>\n\n\n\n

Veritaban\u0131,tablo,index,prosedure,fonksiyon vb. database nesnelerini olu\u015fturmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n

CREATE TABLE tablo_adi\n(s\u00fctun_adi_1) veri_tipi,\n(s\u00fctun_adi_2) veri_tipi,\n\u2026\u2026\u2026);<\/code><\/pre>\n\n\n\n
Tabloda her bir alan bilgisinden sonra alanlar\u0131 birbirinden ay\u0131rt etmek i\u00e7in virg\u00fcl konulur.<\/p>\n\n\n\n
Sorgunun bitti\u011fini ve \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 gerekti\u011fini belirtmek i\u00e7in noktal\u0131 virg\u00fcl konulur.<\/p>\n\n\n\n
CREATE TABLE<\/mark> [Hata](\n[HataId] [int] IDENTITY(1,1) NOT NULL,\n[HataTipId] [int] NOT NULL,\n[HataGrupId] [int] NOT NULL,\n[Hata] [nvarchar](50) NOT NULL,\n[HataKod] [nvarchar](50) NOT NULL);<\/code><\/pre>\n\n\n\n
NOT NULL ifadesi, tabloya veri yazarken bu alan\u0131n bo\u015f ge\u00e7ilemez oldu\u011funu belirtir.<\/p>\n\n\n\n
ALTER<\/mark><\/p>\n\n\n\n
\u00d6nceden yarat\u0131lm\u0131\u015f tablonun yap\u0131s\u0131nda de\u011fi\u015fiklik i\u015flemi i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n
Yeni bir alan ekleme, veri tipin de de\u011fi\u015fiklik, k\u0131s\u0131t i\u015flemleri; ekleme silme de\u011fi\u015ftirme i\u015flemlerinde kullan\u0131l\u0131r.<\/p>\n\n\n\n
ALTER TABLE [Hata]\nMODIFY[Hata] [nvarchar](150) NOT NULL<\/code><\/pre>\n\n\n\n
ALTER TABLE<\/mark> [HATA]\n ADD <\/mark>[FormId] [int] NOT NULL<\/code><\/pre>\n\n\n\n
Hata tablosun integer tipinde FormId alan\u0131 eklenmi\u015ftir.<\/p>\n\n\n\n
DROP<\/mark><\/p>\n\n\n\n
Tabloyu silmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n
DROP TABLE<\/mark> table_name [CASCADE CONSTRAINTS]<\/mark><\/code><\/pre>\n\n\n\n
Cascade Constraints<\/mark> ; ili\u015fkili tablolardaki master beraber detay tablolar\u0131nda otomatik olarak silinmesi sa\u011flan\u0131r. Bu ifade kullan\u0131lmazsa detay tablolar silinmez. Sadece table_name <\/mark>verdi\u011finiz tablo silinir.<\/p>\n\n\n\n
INSERT<\/mark><\/p>\n\n\n\n
Tabloya veri eklemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n
INSERT INTO<\/mark> table_name (alan_adi_1, alan_adi_2)\nVALUES <\/mark>(deger_1, deger_2)\n<\/code><\/pre>\n\n\n\n
INSERT INTO <\/mark>HATA (HataTipId,HataGrupId,Hata,HataKod) VALUES<\/mark>(1,1,'01','YIKAMA')<\/code><\/pre>\n\n\n\n
HataId <\/mark>alan\u0131 IDENTITY alan oldu\u011fu i\u00e7in kolon otomatik kendi art\u0131rarak de\u011feri verecektir.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
CREATE Veritaban\u0131,tablo,index,prosedure,fonksiyon vb. database nesnelerini olu\u015fturmak i\u00e7in kullan\u0131l\u0131r. Tabloda her bir alan bilgisinden sonra alanlar\u0131 birbirinden ay\u0131rt etmek i\u00e7in virg\u00fcl konulur. Sorgunun bitti\u011fini ve \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 gerekti\u011fini belirtmek i\u00e7in noktal\u0131 virg\u00fcl konulur. NOT NULL ifadesi, tabloya veri yazarken bu alan\u0131n bo\u015f ge\u00e7ilemez oldu\u011funu belirtir. ALTER \u00d6nceden yarat\u0131lm\u0131\u015f tablonun yap\u0131s\u0131nda de\u011fi\u015fiklik i\u015flemi i\u00e7in kullan\u0131l\u0131r. Yeni bir alan […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-128","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/pages\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":16,"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/pages\/128\/revisions"}],"predecessor-version":[{"id":153,"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/pages\/128\/revisions\/153"}],"wp:attachment":[{"href":"https:\/\/www.esraturan.com.tr\/index.php\/wp-json\/wp\/v2\/media?parent=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}