Total Page Preview: 000000001778
What is drop statement in SQL in English and Hindi
Drop statement in Engilsh
The DROP statement in SQL is used to remove or delete an object from a database, such as a table, view, index, or stored procedure. The syntax for the DROP statement is:
Here, OBJECT_TYPE can be replaced with the type of object you want to drop, such as TABLE, VIEW, INDEX, PROCEDURE, etc. OBJECT_NAME is the name of the object you want to drop.
The optional IF EXISTS clause checks whether the object exists before dropping it, to prevent errors if the object does not exist.
For example, to drop a table named "Employees", the syntax would be:
If you want to check whether the table exists before dropping it, you can use the following syntax:
This statement will drop the "Employees" table only if it exists in the database.
Drop statement in Hindi
Drop statement SQL mein use kiya jaata hai to delete ya remove karna ke liye kisi database object ko jaise table, view, index, stored procedure, trigger, etc. Drop statement se object permanently delete ho jaata hai.
Drop statement ka syntax SQL server ke liye is tarah hota hai:
Yahaan OBJECT_TYPE ko us database object ki type ke saath replace kiya jaata hai jisko aap delete karna chahte hain jaise ki TABLE, VIEW, INDEX, PROCEDURE, etc. Aur OBJECT_NAME ko us object ke naam ke saath replace kiya jaata hai jisko aap delete karna chahte hain.
For example, agar aap ek table 'employees' ko delete karna chahte hain, toh aapka drop statement is tarah ka hoga:
Is tarah ke statement ke baad 'employees' table permanently delete ho jayega aur uski definition aur data sabhi se remove ho jaayega.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com