MS SQL Server: DROP TABLE Command in SQL Server

In SQL Server, the DROP TABLE command helps delete a table from the database.

Syntax of DROP TABLE command

 DROP TABLE ten_bang; 

Variable name or variable value

ten_bang

The name of the table you want to delete the database key of SQL Server.

As an example,

 DROP TABLE is available; 

The command in the above example will delete the table from the current database in SQL Server. But if the table you want to delete is not in the current database but in another database, see how to delete the table in another database below.

 DROP TABLE cosodulieu2.dbo.nhacung; 

As an example,, the above DROP TABLE command will delete the table that is not in the current database but in the database named cosodulieu2.

Because of the mention of the CASL name, the DROP TABLE command can execute on any database of the server installation (as long as you have the right to execute the command).

Now see the example of deleting LOCAL TEMPORARY TABLE with the DROP TABLE command. Remember that LOCAL TEMPORARY TABLE comes with the # character in front.

 DROP TABLE #nhanvien;