Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to drop a database in sql server when it is in use

BY LOVE SINGH

USE master;
GO
ALTER DATABASE OnlineRestaurant2 
SET SINGLE_USER 
WITH ROLLBACK IMMEDIATE;
GO
DROP DATABASE OnlineRestaurant2;
Comment

SQL Server DROP DATABASE

DROP DATABASE DB_NAME
Comment

PREVIOUS NEXT
Code Example
Sql :: importing excel data into sql server 
Sql :: WHERE not regex in SQL 
Sql :: SQL Database backup history 
Sql :: sql select lowest value row 
Sql :: mysql vs postgresql 
Sql :: login phpmyadmin without password 
Sql :: oracle dependency 
Sql :: SQL Add Column in a Table 
Sql :: mysql wont stop 
Sql :: postgres integer to serial 
Sql :: open postgresql.conf 
Sql :: call postgres function 
Sql :: codeigniter get sql query string 
Sql :: odd record sql query 
Sql :: sql server delete table 
Sql :: sql update multiple rows 
Sql :: rollback in sql 
Sql :: what is having clause in sql 
Sql :: SQL Syntax of LEFT JOIN 
Sql :: sql alchemy or 
Sql :: mongodb vs mysql 
Sql :: sql String comparisons case sensitive 
Sql :: pl sql create table from another table 
Sql :: sql order by two columns 
Sql :: oracle chain rules 
Sql :: sqlite commands 
Sql :: import mysql database command line 
Sql :: 0 
Sql :: how to change server name in sql server 
Sql :: how to find top 3 salary in sql 
ADD CONTENT
Topic
Content
Source link
Name
4+2 =