SQL DROP TABLE, DROP DATABASE and DROP INDEX

DROP TABLE :-Drop table statement is used to delete the table. 

Syntax :- 

  
DROP TABLE table_name



DROP DATABASE :-Drop database statement is used to delete the database. 

Syntax :- 

  
DROP DATABASE database_name



DROP INDEX :-Drop index statement is used to delete index in table. 

Syntax :- 

  
DROP INDEX table_name.index_name


No comments:

Post a Comment

How to register multiple implementations of the same interface in Asp.Net Core?

 Problem: I have services that are derived from the same interface. public interface IService { } public class ServiceA : IService { ...