Ramazan HABER / MSSQL RMOS / delete all fk drop the foreign key
1-) MSSQL RMOS - delete all fk drop the foreign key
1- HATA
2- ÇÖZÜMÜ(VERİ TABANINDAKİ TÜM FOREGİN YANİ YABANCIL ANAHTARLARI SİLER)
DECLARE @SQL varchar(4000)='' SELECT @SQL = @SQL + 'ALTER TABLE ' + s.name+'.'+t.name + ' DROP CONSTRAINT [' + RTRIM(f.name) +'];' + CHAR(13) FROM sys.Tables t INNER JOIN sys.foreign_keys f ON f.parent_object_id = t.object_id INNER JOIN sys.schemas s ON s.schema_id = f.schema_id --PRINT @SQL EXEC (@SQL)
|
3- UYGULAMASI(VERİ TABANINA NEW QUERY DERSİN YUKARIDAKİ KODU YAPIŞTIRIP EXECUTE DERSİN)
2023 Mayıs 31 Çarşamba
720
720