<\/div>\n

Bu yaz\u0131m\u0131zda T-SQL de DDL(Data Definition Language) kavramlar\u0131n\u0131 g\u00f6rece\u011fiz.T-SQL de veritaban\u0131 nesneleri yaratmam\u0131z\u0131 sa\u011flayan ve bu nesneler \u00fczerinde de\u011fi\u015fiklikler yapmam\u0131z\u0131 ve silmemizi sa\u011flayan yap\u0131lar bu ba\u015fl\u0131k alt\u0131nda simgilenmektedir.
\nDDL (DATA DEFINITION LANGUAGE)<\/span><\/strong>
\n\u00d6ncelikle yap\u0131lar\u0131 teker teker \u00f6zetleyip sonra ayr\u0131nt\u0131ya girelim..<\/p>\n

CREATE :\u00a0<\/span> Veritaban\u0131 nesnesi yaratmam\u0131z\u0131 sa\u011flar(database,table,view,storedproc,trigger v.s)
\nALTER :<\/span> Create ile yarat\u0131lan veritaban\u0131 nesnelerinde de\u011fi\u015fiklik yapmam\u0131z\u0131 sa\u011flar.
\nDROP :<\/span> Create ile olu\u015fturulan veritaban\u0131 nesnelerini silmemize yarar.
\nCREATE<\/span>
\nYukar\u0131da bahsetti\u011fimiz gibi veritaban\u0131 nesnesi yaratmam\u0131z\u0131 sa\u011flar.
\nGenel anlamda kullan\u0131m\u0131 \u015f\u00f6yledir.
\nCreate \u2013nesnetipi- nesnenin ismi
\nDatabase Olu\u015fturma,<\/p>\n

\n
\r\ncreate database GG\r\n<\/pre>\n
\n
Bu yap\u0131yla varsay\u0131lan(default) ayarlarda bir veritaban\u0131 olu\u015fturmu\u015f oluyoruz.<\/p>\n
E\u011fer olu\u015fturaca\u011f\u0131m\u0131z veritaban\u0131n\u0131n detay \u00f6zelliklerinide T-SQL arac\u0131l\u0131yla iste\u011fimize g\u00f6re vermek istiyorsak e\u011fer a\u015fa\u011f\u0131daki yap\u0131y\u0131 kullanmal\u0131y\u0131z.<\/p>\n
\n
\r\ncreate database GG\r\non\r\n(\r\nname='GG', -- Veritaban\u0131 ismini yaz\u0131yoruz.\r\nfilename='C:\\GG.mdf', -- Veritaban\u0131n\u0131n hangi konumda olu\u015faca\u011f\u0131n\u0131 yaz\u0131yoruz.\r\nsize=5, -- Veritaban\u0131n\u0131n ba\u015flang\u0131\u00e7 boyutunu ayarl\u0131yoruz.(mb)\r\nfilegrowth=3 -- Veritaban\u0131n\u0131n ba\u015flang\u0131\u00e7 boyutunu ge\u00e7ti\u011finde boyutunun ne kadar artmas\u0131 gerekti\u011fini yaz\u0131yoruz.(mb)\r\n)\r\nLog \u2013 Veritaban\u0131n log dosyas\u0131n\u0131da istedi\u011fimiz \u00f6zellikte olu\u015fturabiliyoruz.\r\non\r\n(\r\nname='GG_LOG',\r\nfilename='C:\\GG.ldf',\r\nsize=5,\r\nfilegrowth=3\r\n)\r\n<\/pre>\n
\n
Tablo Olu\u015fturma,
\nYukar\u0131da olu\u015fturdu\u011fumuz GG isimli veritaban\u0131na bir tablo olu\u015ftural\u0131m.<\/p>\n
\n
\r\nuse GG\r\ncreate table ggtablo\r\n(\r\nGGId int,\r\nGGAdi nvarchar(50),\r\nGGSoyadi nvarchar(50)\r\n)\r\n<\/pre>\n
\n
Tabloyu olu\u015ftururken kolonlar\u0131n\u0131da haz\u0131rl\u0131yoruz.\u00d6nce kolon ad\u0131n\u0131 yaz\u0131p sonra tipini yaz\u0131yoruz.<\/p>\n
\n
\r\ncreate table ggtablo2\r\n(\r\n[GG Id] int, -- E\u011fer kolon isimlerinde bo\u015fluk kullanacaksak [] aras\u0131na yaz\u0131yoruz.\r\n[GGAdi GGSoyadi] nvarchar(50)\r\n)\r\n<\/pre>\n
\n
Ben T-SQL de olu\u015fturdu\u011fum bir kolonun primary key \u00f6zelli\u011fine sahip olmas\u0131n\u0131 ve identity \u00f6zelli\u011finin istedi\u011fim \u015fekilde artmas\u0131n\u0131 ayarlamak istiyorum.Onuda \u015fu \u015fekilde yapabilirim.<\/p>\n
\n
\r\ncreate table ggOgretmen\r\n(\r\nOgretmenId int primary key identity(1,1),--Ben OgretmenId kolonunun primary key olmas\u0131n\u0131 istiyorum ve identity \u00f6zelli\u011fiyle 1 den ba\u015flay\u0131p birer birer artmas\u0131n\u0131 istiyorum.\r\nOgretmenAdi nvarchar(50),\r\nOgretmenSoyadi nvarchar(50)\r\n)\r\n<\/pre>\n
\n
ALTER<\/span>
\nCreate ile yarat\u0131lan nesneler \u00fczerinde de\u011fi\u015fiklik yapmam\u0131z\u0131 sa\u011flard\u0131.
\nCreate ile olu\u015fturdu\u011fumuz \u201cGG\u201d isimli veritaban\u0131n\u0131n \u201csize\u201d \u00f6zelli\u011fini de\u011fi\u015ftirelim.<\/p>\n
\n
\r\nalter database GG\r\nmodify file\r\n(\r\nname='GG',-- GG dosyas\u0131n\u0131 de\u011fi\u015ftir.\r\nsize=20 \u2013- size 20 olsun.\r\n)\r\n<\/pre>\n
\n
Size \u00f6zelli\u011fi herzaman artt\u0131r\u0131labilir ancak azalt\u0131lamaz.
\nHerhangi bir tabloda kolonun \u00f6zelli\u011fini de\u011fi\u015ftirmek,<\/p>\n
\n
\r\nalter table ggOgrenci\r\nalter column OgrenciSoyadi varchar(20) not null\r\n<\/pre>\n
\n
DROP<\/span>
\nCreate ile olu\u015fturulan nesneleri silmemize yarar.
\nTablo silme,<\/p>\n
\n
\r\ndrop table ggOgrenci\r\n<\/pre>\n
\n
Tablodan kolon silme,<\/p>\n
\n
\r\nalter table ggOgrenci\r\ndrop column OgrenciAdi\r\n<\/pre>\n
\n
Database silme,<\/p>\n
\n
\r\ndrop database GG\r\n<\/pre>\n
\n","protected":false},"excerpt":{"rendered":"
Bu yaz\u0131m\u0131zda T-SQL de DDL(Data Definition Language) kavramlar\u0131n\u0131 g\u00f6rece\u011fiz.T-SQL de veritaban\u0131 nesneleri yaratmam\u0131z\u0131 sa\u011flayan ve bu nesneler \u00fczerinde de\u011fi\u015fiklikler yapmam\u0131z\u0131 ve silmemizi sa\u011flayan yap\u0131lar bu ba\u015fl\u0131k alt\u0131nda simgilenmektedir.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[108,85],"class_list":["post-168","post","type-post","status-publish","format-standard","hentry","category-veritabani","tag-ddl","tag-transact-sql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=168"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/168\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}