{"id":741,"date":"2014-08-19T16:24:27","date_gmt":"2014-08-19T14:24:27","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=741"},"modified":"2014-08-19T16:26:01","modified_gmt":"2014-08-19T14:26:01","slug":"mssql-serverda-bir-database-e-ait-tum-tablolariiliskileri-store-procedurleriview-lerifunctionlari-silmek","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2014\/08\/mssql-serverda-bir-database-e-ait-tum-tablolariiliskileri-store-procedurleriview-lerifunctionlari-silmek\/","title":{"rendered":"Mssql Serverda Bir database e ait t\u00fcm tablolar\u0131,ili\u015fkileri, store procedurleri,view leri,functionlar\u0131 silmek"},"content":{"rendered":"

Tablolar\u0131 Silmek<\/strong><\/p>\n

<\/a>Source code<\/a><\/td><\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>
EXEC sp_MSForEachTable 'DROP TABLE ?'<\/span>\nGO<\/pre><\/div><\/div>\n
Tablolar aras\u0131 ili\u015fkileri silmek<\/strong><\/p>\n
<\/a>Source code<\/a><\/td><\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>
DECLARE @Sql NVARCHAR(<\/span>500)<\/span>\nDECLARE @Cursor CURSOR\nSET<\/span> @Cursor =<\/span> CURSOR FAST_FORWARD FOR<\/span>\n \nSELECT<\/span> DISTINCT<\/span> sql =<\/span> 'ALTER TABLE ['<\/span> +<\/span> TableCons.<\/span>TABLE_NAME +<\/span>\n        '] DROP ['<\/span> +<\/span> ReferentialCons.<\/span>CONSTRAINT_NAME +<\/span> ']'<\/span>\nFROM<\/span> INFORMATION_SCHEMA.<\/span>REFERENTIAL_CONSTRAINTS ReferentialCons\nLEFT<\/span> JOIN<\/span> INFORMATION_SCHEMA.<\/span>TABLE_CONSTRAINTS TableCons\nON<\/span> TableCons.<\/span>CONSTRAINT_NAME =<\/span> ReferentialCons.<\/span>CONSTRAINT_NAME\n \nOPEN @Cursor FETCH NEXT FROM<\/span> @Cursor INTO<\/span> @Sql\nWHILE (<\/span>@@FETCH_STATUS =<\/span> 0)<\/span>\nBEGIN\n    Exec SP_EXECUTESQL @Sql\n    FETCH NEXT FROM<\/span> @Cursor INTO<\/span> @Sql\nEND\nCLOSE @Cursor DEALLOCATE @Cursor\nGO<\/pre><\/div><\/div>\n
View\u2019lar\u0131 silmek<\/strong><\/p>\n
<\/a>Source code<\/a><\/td><\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>
DECLARE @query VARCHAR(<\/span>MAX)<\/span> =<\/span> ''<\/span>;\nSELECT<\/span> @query =<\/span> @query +<\/span> 'DROP VIEW ['<\/span> +<\/span> name +<\/span> '];'<\/span> FROM<\/span> sys.<\/span>views;\nEXEC(<\/span>@query)<\/span>;<\/pre><\/div><\/div>\n
Stored Procedur\u2019leri silmek<\/strong><\/p>\n
<\/a>Source code<\/a><\/td><\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>
DECLARE @procedureName VARCHAR(<\/span>500)<\/span>\nDECLARE cur CURSOR\n \nFOR<\/span> SELECT<\/span> [<\/span>name]<\/span> FROM<\/span> sys.<\/span>objects WHERE<\/span> TYPE =<\/span> 'p'<\/span>\nOPEN cur\nFETCH NEXT FROM<\/span> cur INTO<\/span> @procedureName\n \nWHILE @@fetch_status =<\/span> 0<\/span>\nBEGIN\n    EXEC(<\/span>'DROP PROCEDURE '<\/span> +<\/span> @procedureName)<\/span>\n    FETCH NEXT FROM<\/span> cur INTO<\/span> @procedureName\nEND\n \nCLOSE cur\nDEALLOCATE cur<\/pre><\/div><\/div>\n
Fonksiyonlar\u0131 silmek<\/strong><\/p>\n
<\/a>Source code<\/a><\/td><\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>
DECLARE @functionName VARCHAR(<\/span>500)<\/span>\nDECLARE cur CURSOR\n \nFOR<\/span> SELECT<\/span> [<\/span>name]<\/span> FROM<\/span> sys.<\/span>objects WHERE<\/span> TYPE =<\/span> 'fn'<\/span>\nOPEN cur\nFETCH NEXT FROM<\/span> cur INTO<\/span> @functionName\n \nWHILE @@fetch_status =<\/span> 0<\/span>\nBEGIN\n    EXEC(<\/span>'DROP FUNCTION '<\/span> +<\/span> @functionName)<\/span>\n    FETCH NEXT FROM<\/span> cur INTO<\/span> @functionName\nEND\n \nCLOSE cur\nDEALLOCATE cur<\/pre><\/div><\/div>\n
Ayhan ARDA<\/p>\n
\"Share<\/a>