DEFINITIONS

Definitions More Info.
Definition ID558
TitleSQL
CategoryNOTES
DefinitionCreateIndex_DropIndex_OnTable
Definition Descriptionuse yuksel go create table musteri ( musterino int,
mad varchar(50) NULL,
mtel varchar(50) NULL,
madres varchar(50) NULL ) go
insert
into
musteri
values (101,
'sener sen',
'05324444444',
'kadıköy')
insert
into
musteri
values (102,
'sezen aksu',
'0542111111',
'erenköy')
insert
into
musteri
values (103,
'ali sen',
'0532222222,',
'kadıköy')
insert
into
musteri
values (104,
'barıs manço',
'05322455555,',
'kadıköy')
insert
into
musteri
values (105,
'kemal sunal',
'05429333333,',
'erenköy')
insert
into
musteri
values (103,
'ayşegül aldinç',
'05426666666,',
'kadıköy') go
-- clustered index oluşturma create clustered index cl_musterino on musteri ( musterino asc ) go -- index drop drop index cl_musterino on musteri go
RecordBycunay
Record Date04-07-2014 17:46:45
Düzenle
Kopyala
Sil