Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 21271 invoked from network); 19 Jul 2009 07:15:20 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 19 Jul 2009 07:15:20 -0000 Received: (qmail 83459 invoked by uid 500); 19 Jul 2009 07:16:25 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 83380 invoked by uid 500); 19 Jul 2009 07:16:25 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 83372 invoked by uid 99); 19 Jul 2009 07:16:25 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Jul 2009 07:16:25 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of devatha.sridhar@gmail.com designates 209.85.220.205 as permitted sender) Received: from [209.85.220.205] (HELO mail-fx0-f205.google.com) (209.85.220.205) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Jul 2009 07:16:16 +0000 Received: by fxm1 with SMTP id 1so1437926fxm.7 for ; Sun, 19 Jul 2009 00:15:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=4HvouxJmnaGK/Ak3RkedkgPMWVu1G8g7Y+ZNRBd0s2w=; b=vuvhYaH1hKKV5q9IjBYILjZGHHgj+KiVdG7cOyhxXpQ+VWyCUYhT+THQjyhGdRNoqQ zgc8H6UDZGlJiwLeJPdHJohnVhicBBR34QkgyFgC9/QZwTvpfBlxQSVP7Bopg3qlH8s4 rXiIqJADBGU1hwV7mMju9X/zIAZc8kKdtppdg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=hRP4PUrc4kBwTYlE+A0uRCQ0/7PzJWqMSEemeuyNX6crupXhmVHmpUMQEZoRCbO6Im l/jgNk1cnlezBkBkW2/l+AOlcgIfvHFfZe2mqlqq1sdlnxbzAYM5lKbyGmd7BubCy+Fj ksZKcW1Wf67A9tGbnAdH6jAhtWL76ovr3nJHI= MIME-Version: 1.0 Received: by 10.223.115.193 with SMTP id j1mr874930faq.98.1247987755616; Sun, 19 Jul 2009 00:15:55 -0700 (PDT) Date: Sun, 19 Jul 2009 12:45:55 +0530 Message-ID: Subject: deleting database From: sridhar devatha To: derbyPosting Content-Type: multipart/alternative; boundary=001636c5b8efdb8d4f046f09ca00 X-Virus-Checked: Checked by ClamAV on apache.org --001636c5b8efdb8d4f046f09ca00 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi, I hava a database, let us call it, sampleDB. I connect to it using ij through the below command. connect 'jdbc:derby://localhost:1527/sampleDB;create=false'; I want to remove sampleDB. So that nobody can connect to it even using sys schema. This database is in different schema other than sys and app. I am unable to find in docs and google on deleting derby database. Can I delete it from my own schema from which I usually connect to this database? what is the command for deleting database? how to know the tables / data in the database? bye sridhar -- Yours Sincerely, Devatha Sridhar --001636c5b8efdb8d4f046f09ca00 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,
=A0
I hava a database, let us call it, sampleDB.
I connect to it using ij through the below command.
connect 'jdbc:derby://localhost:1527/sampleDB;create=3Dfalse';=
I want to remove sampleDB. So that nobody can connect to it even using= sys schema.
This database is in different schema other than sys and app.
I am unable to find in docs and google on deleting derby database.
Can I delete it from my own schema from which I usually connect to thi= s database?
what is the command for deleting database?
how to know the tables / data in the database?
=A0
=A0
bye
sridhar

--

Yours Sincerely,
Devatha Sridhar
--001636c5b8efdb8d4f046f09ca00--