Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 2004 invoked from network); 10 Apr 2006 02:56:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 10 Apr 2006 02:56:34 -0000 Received: (qmail 90121 invoked by uid 500); 10 Apr 2006 02:56:34 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 90106 invoked by uid 500); 10 Apr 2006 02:56:33 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 90095 invoked by uid 99); 10 Apr 2006 02:56:33 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Apr 2006 19:56:33 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of allanjunli@gmail.com designates 64.233.184.234 as permitted sender) Received: from [64.233.184.234] (HELO wproxy.gmail.com) (64.233.184.234) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Apr 2006 19:56:33 -0700 Received: by wproxy.gmail.com with SMTP id i12so737633wra for ; Sun, 09 Apr 2006 19:56:12 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=fOsUS3r12jwMYMq12bKB8RY8MxTzWkcBeUpDSENqgh7Qq85/EYOXOBaxgn2gLNIUMtJgXxwnQHBbgzx39kL7tz2YFXZtPgoUULbsk6yH/9i6tyTzH37ZWDigpEyPZocSdIMJaxPs6MCDpHHZ0JkmIvDuIPizHFM2b1SPKTA94lw= Received: by 10.65.52.3 with SMTP id e3mr3819076qbk; Sun, 09 Apr 2006 19:56:12 -0700 (PDT) Received: by 10.65.121.7 with HTTP; Sun, 9 Apr 2006 19:56:12 -0700 (PDT) Message-ID: Date: Mon, 10 Apr 2006 12:56:12 +1000 From: "Jun Li" To: ddlutils-user@db.apache.org Subject: Re: Didn't filter table dtproperties on SQL Server. In-Reply-To: <224f32340604091138y51910a1o9f926e0f96f737b1@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24873_14339222.1144637772181" References: <224f32340604040600x51c4350eg2f9864b2ae3dc8e1@mail.gmail.com> <224f32340604091138y51910a1o9f926e0f96f737b1@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_24873_14339222.1144637772181 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 4/10/06, Thomas Dudziak wrote: > > On 4/7/06, Jun Li wrote: > > > The problem is that dtproperties is not a system table, it is a normal > table (of type TABLE) so DdlUtils cannot really know whether it is a > table the user wants or not. I've updated the issue accordingly to > specify a feature request for table include/exclude patterns which > would also cover this case. > > Tom > In SQL Server Enterprise Manager, you'll find that the type of dtproperties is "System" the same as those tables start with sys like syscolumns, sysindexes, etc. In particular, dtproperties stores information about the diagrams. Anyway, include/exclude patterns would be more useful. But how to define those patterns and when to use it, please tell us more info. I couldn't fin= d it in the javadoc. -- -------------- Cheers, Jun ------=_Part_24873_14339222.1144637772181--