Delete Complete Table and Information in SQL Server Using Stored Procedure

-
DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR
SET @Cursor = CURSOR FAST_FORWARD FOR
SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME=rc1.CONSTRAINT_NAME
OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql
WHILE (@@FETCH_STATUS = 0)
BEGIN
Exec SP_EXECUTESQL @Sql
FETCH NEXT FROM @Cursor INTO @Sql
END
CLOSE @Cursor DEALLOCATE @Cursor
GO
EXEC sp_MSForEachTable 'DROP TABLE ?'
GO


Comments

Post a Comment

Thank You for your Comment

Popular posts from this blog

Display Canvasjs Line Chart using Data from Database

-
Image
Aspx Page: <% @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="Canvasjs.aspx.cs" Inherits ="BloggerCont.Canvasjs" %> < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < script src ="jquery-1.7.1.js" type ="text/javascript"></ script >     < script src ="canvasjs.min.js" type ="text/javascript"></ script >     < script type ="text/javascript">         $(document).ready( function () {             Disp();         });         function Disp() {             var dataPts = [];             var var1;         ...
Read more

What are the SOLID principles, and why are they important

-
 The SOLID principles are a set of five design principles in object-oriented programming that help developers create more understandable, flexible, and maintainable software. These principles were introduced by Robert C. Martin, also known as Uncle Bob. They are: Single Responsibility Principle (SRP) Open/Closed Principle (OCP) Liskov Substitution Principle (LSP) Interface Segregation Principle (ISP) Dependency Inversion Principle (DIP) 1. Single Responsibility Principle (SRP) A class should have only one reason to change, meaning it should have only one job or responsibility. Importance: Promotes cohesive functionality. Simplifies debugging and testing. Makes the system more understandable and reduces the risk of changes affecting unrelated functionalities. 2. Open/Closed Principle (OCP) Software entities (classes, modules, functions, etc.) should be open for extension but closed for modification. Importance: Encourages code reuse and flexibility. Reduces the risk of introducing b...
Read more

Write Text in Notepad files Using Asp.net

-
                In asp.net Provide many Supporting Classes and Objects files. To write Text or data in Notepad Files Using Your Asp.net and windows Applications. Using StreamWriter Class to write a Text files in Notepad.    Using Class file  using  System.IO  and point to the Text files and open the text files. StreamWriter  streamwriter; streamwriter=  new   StreamWriter ( File .Open(Server.MapPath( "~/sample.txt" ),  FileMode .OpenOrCreate));         streamwriter.WriteLine( " ******************************** " );         streamwriter.WriteLine( "         Heading    " );   streamwriter.WriteLine( "          ***************        " );   ...
Read more