ChinookDatabase Forum Rss Feed

New Post: DROP DATABASE if database exists (SQLServer)

sadkamikaze — Sat, 21 Nov 2009 13:46:24 GMT

If I start CreateDB.sql and database already exists and used (connections to database is opened) database not droped

Solution could be add additional logic

CreateDb.sql LINE:10

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Chinook')

BEGIN

ALTER DATABASE [Chinook]

SET OFFLINE

WITH ROLLBACK IMMEDIATE;

ALTER DATABASE [Chinook]

SET ONLINE;

DROP DATABASE [Chinook];

END

CREATE DATABASE [Chinook];

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Chinook')

BEGIN

--Take database offline ignoring any connection made

ALTER DATABASE [Chinook]

SET OFFLINE

WITH ROLLBACK IMMEDIATE;

--Bring online before delete

ALTER DATABASE [Chinook]

SET ONLINE;

DROP DATABASE [Chinook];

END

CREATE DATABASE [Chinook];

lerocha — Sat, 29 Aug 2009 19:19:56 GMT

Yes, sure! If you have already a SQLite version and want to share it, I can include it on the next version. Thanks!

Luis

NelsonCabral — Sat, 29 Aug 2009 17:14:26 GMT

Are you interested in the SQLite version of your Chinook db?

lerocha — Tue, 07 Jul 2009 03:44:47 GMT

No, there is no domain model for it. There is just the physical database schema:

fabiomaulo — Thu, 02 Jul 2009 16:28:07 GMT

Do you know is there is, in some place, a domain model of Chinook ?

evoluteur — Fri, 03 Apr 2009 21:58:11 GMT

Great database for demos. I've just used it for a demo of my CRUD framework. Thanks.

http://evolutility.org/Chinook/Chinook_by_Evolutility.aspx