You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-user@db.apache.org by Jun Li <al...@gmail.com> on 2006/04/04 07:31:49 UTC

Didn't filter table dtproperties on SQL Server.

On SQL Server dtproperties is a system table.

But DdlUtils did not filter it out like it does on other system tables like
syscolumns, sysfiles, sysindexes, and so on.

--
--------------
Cheers,
Jun

Re: Didn't filter table dtproperties on SQL Server.

Posted by Jun Li <al...@gmail.com>.
On 4/10/06, Thomas Dudziak <to...@gmail.com> wrote:
>
> On 4/7/06, Jun Li <al...@gmail.com> 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 find
it in the javadoc.


--
--------------
Cheers,
Jun

Re: Didn't filter table dtproperties on SQL Server.

Posted by Thomas Dudziak <to...@gmail.com>.
On 4/7/06, Jun Li <al...@gmail.com> wrote:

> Done. The key is 87.
>
> On 4/4/06, Thomas Dudziak <to...@gmail.com> wrote:
> >
> > On 4/4/06, Jun Li <al...@gmail.com> wrote:
> >
> > > On SQL Server dtproperties is a system table.
> > >
> > > But DdlUtils did not filter it out like it does on other system tables
> > like
> > > syscolumns, sysfiles, sysindexes, and so on.

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

Re: Didn't filter table dtproperties on SQL Server.

Posted by Jun Li <al...@gmail.com>.
Done. The key is 87.

On 4/4/06, Thomas Dudziak <to...@gmail.com> wrote:
>
> On 4/4/06, Jun Li <al...@gmail.com> wrote:
>
> > On SQL Server dtproperties is a system table.
> >
> > But DdlUtils did not filter it out like it does on other system tables
> like
> > syscolumns, sysfiles, sysindexes, and so on.
>
> Could you create an issue in JIRA to that I don't forget about this ?!
>
> Tom
>



--
--------------
Cheers,
Jun

Re: Didn't filter table dtproperties on SQL Server.

Posted by Thomas Dudziak <to...@gmail.com>.
On 4/4/06, Jun Li <al...@gmail.com> wrote:

> On SQL Server dtproperties is a system table.
>
> But DdlUtils did not filter it out like it does on other system tables like
> syscolumns, sysfiles, sysindexes, and so on.

Could you create an issue in JIRA to that I don't forget about this ?!

Tom