select StokNo,COUNT(*) STOKKARTI_NO from STOKKARTI   GROUP BY StokNo HAVING COUNT (StokNo )>1
select Kodu,COUNT(*) STOKKARTI_KODU from STOKKARTI     GROUP BY Kodu  HAVING COUNT (Kodu  )>1
select Barkodu ,COUNT(*) STOKKARTI_BARKODU from STOKKARTI     GROUP BY Barkodu   HAVING COUNT (Barkodu   )>1

select * from STOKKARTI where Barkodu in (select Barkodu  STOKKARTI_BARKODU from STOKKARTI     GROUP BY Barkodu   HAVING COUNT (Barkodu   )>1)

--select StokNo,COUNT(*) Tevkifat_NO from Tevkifat    GROUP BY StokNo HAVING COUNT (StokNo )>1
select Barkodu ,COUNT(*) StokBarkodlari_BARKODU from StokBarkodlari      GROUP BY Barkodu   HAVING COUNT (Barkodu   )>1

select StokNo,COUNT(*) StokFiyat_NO from StokFiyat    GROUP BY StokNo HAVING COUNT (StokNo )>1
select Kodu,COUNT(*) StokFiyat_KODU from StokFiyat     GROUP BY Kodu  HAVING COUNT (Kodu  )>1

---CARİ KARTLAR 
select MUSKOD,COUNT(*) CARI_KODU from AMUSTERI      GROUP BY MUSKOD   HAVING COUNT (MUSKOD  )>1
select MUSNO ,COUNT(*) CARI_KODU from AMUSTERI      GROUP BY MUSNO   HAVING COUNT (MUSNO  )>1


--KODU AYNI NOSU FARKLI ÜRÜNLERİ BUL
UPDATE n  SET StokNo = k2.SIRA  FROM STOKKARTI  n , (select Kodu,StokNo,NoId,RANK () OVER (order  BY   Kodu DESC) SIRA FROM STOKKARTI) k2 where n.Kodu=k2.Kodu 


select * from STOKKARTI order by StokNo 

ALTER TABLE STOKKARTI ADD CONSTRAINT UQ_STOKKARTI_NO UNIQUE (StokNo) 
ALTER TABLE STOKKARTI ADD CONSTRAINT UQ_STOKKARTI_KOD UNIQUE (Kodu) 
ALTER TABLE STOKKARTI ADD CONSTRAINT UQ_STOKKARTI_BARKOD UNIQUE (Barkodu) 

ALTER TABLE StokBarkodlari ADD CONSTRAINT UQ_StokBarkodlari_Barkodu UNIQUE(Barkodu)

ALTER TABLE StokFiyat ADD CONSTRAINT UQ_StokFiyat_No UNIQUE(StokNo)
ALTER TABLE StokFiyat ADD CONSTRAINT UQ_StokFiyat_Kodu UNIQUE(Kodu)

ALTER TABLE AMUSTERI ADD CONSTRAINT UQ_AMUSTERI_MUSNO UNIQUE (MUSNO) 
ALTER TABLE AMUSTERI ADD CONSTRAINT UQ_AMUSTERI_MUSKOD UNIQUE (MUSKOD) 

 SELECT * FROM sys.foreign_keys

  SELECT * FROM sys.check_constraints

  ---unıque const raporu
 SELECT     TABLE_NAME,     CONSTRAINT_NAME ,CONSTRAINT_TYPE FROM     INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE     CONSTRAINT_TYPE = 'UNIQUE'      AND TABLE_SCHEMA = 'dbo' order by 1
 SELECT     TABLE_NAME,     CONSTRAINT_NAME ,CONSTRAINT_TYPE FROM     INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE     CONSTRAINT_TYPE = 'CHECK'      AND TABLE_SCHEMA = 'dbo' order by 1
 SELECT     TABLE_NAME,     CONSTRAINT_NAME,CONSTRAINT_TYPE FROM     INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE      CONSTRAINT_TYPE LIKE '%FOREIGN%'      AND  TABLE_SCHEMA = 'dbo' order by 1


--- 
 declare @CNTNAME NVARCHAR(100),@SQL NVARCHAR(MAX)
select @CNTNAME=name from sys.foreign_keys where name like 'FK__StokFiyat__Kodu%'
SET @SQL='ALTER TABLE [dbo].[StokFiyat] DROP CONSTRAINT ['+ CONVERT(VARCHAR(100),@CNTNAME)+']'
EXEC(@SQL)

---Constları silme
alter table STOKKARTI DROP CONSTRAINT UQ__STOKKART__706C7ED82C64FD59
alter table STOKKARTI DROP CONSTRAINT STK_KOD
alter table STOKKARTI DROP CONSTRAINT STK_UQ

alter table StokBarkodlari DROP CONSTRAINT UK_Barkodu

select * from sys.un