package SQL::Translator::Parser::DBI::SQLServer;
# -------------------------------------------------------------------
-# $Id: SQLServer.pm,v 1.4 2006-08-26 11:37:18 schiffbruechige Exp $
-# -------------------------------------------------------------------
-# Copyright (C) 2002-4 SQLFairy Authors
+# Copyright (C) 2002-2009 SQLFairy Authors
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License as
use Data::Dumper;
use vars qw[ $DEBUG $VERSION @EXPORT_OK ];
-$VERSION = sprintf "%d.%02d", q$Revision: 1.4 $ =~ /(\d+)\.(\d+)/;
+$VERSION = '1.60';
$DEBUG = 0 unless defined $DEBUG;
no strict 'refs';
if defined;
} @{$dbh->selectall_arrayref("SELECT DISTINCT object_name(id)
FROM sysindexes
- WHERE indid > 0 and indid < 255 and rows > 0 and
+ WHERE indid > 0 and indid < 255 and
name not like '_WA_Sys%'")};
## slurp objects
} elsif ($table_info->{TABLE_TYPE} eq 'VIEW') {
next if $table_info->{TABLE_NAME} eq 'sysconstraints'
|| $table_info->{TABLE_NAME} eq 'syssegments';
+ next if !$stuff->{view}->{$table_info->{TABLE_NAME}}->{text};
my $view = $schema->add_view(
name =>
$table_info->{TABLE_NAME},
}
foreach my $p (values %{$stuff->{procedures}}) {
+ next if !$p->{text};
my $proc = $schema->add_procedure(
name => $p->{name},
owner => $p->{PROCEDURE_OWNER},