Re: How to return all view names that begin with "vwX"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: rob (rwc1960_at_bellsouth.net)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 06:56:05 -0400

Right... I should have known...
Thanks

"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:%23lJrYDrcEHA.2944@TK2MSFTNGP11.phx.gbl...
> Hi Rob
>
> What version of SQL Server are you using? You should always let us know
when
> asking any question.
>
> If your server is case sensitive, INFORMATION_SCHEMA.TABLES must be upper
> case, and the column names must be upper case also,
>
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "rob" <rwc1960@bellsouth.net> wrote in message
> news:W9YMc.27741$yF.17489@bignews2.bellsouth.net...
> > Hi Eric,
> >
> > When I run it in Query analyzer...
> > Server: Msg 208, Level 16, State 1, Line 1
> > Invalid object name 'information_schema.tables'.
> >
> > Thanks
> >
> > "Eric Sabine" <mopar41@hyott-maily.com> wrote in message
> > news:eRkajAqcEHA.3096@tk2msftngp13.phx.gbl...
> > >
> > > select *
> > > from information_schema.tables
> > > where
> > > table_name like 'vwX%'
> > > and table_type = 'view'
> > >
> > >
> > > hth
> > > Eric
> > >
> > >
> > > "rob" <rwc1960@bellsouth.net> wrote in message
> > > news:7bXMc.20198$GT3.15562@bignews6.bellsouth.net...
> > > > What is the SQL to return the name of all the views in a database
that
> > > begin
> > > > with "vwX" ?
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: OUT OF MEMORY
    ... you are saying that the default upper limit is 128k when created? ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.sqlserver.ce)
  • Re: Cant create Primary Key???
    ... Columnist, SQL Server Professional ... > SQL Server MVP ... > "Rob" wrote in message ... > the primary key I get the error below. ...
    (microsoft.public.sqlserver.server)
  • Re: check constraints and null values
    ... little envelope) on the upper left hand corner of the incorrect topic so ... Books Online has it wrong. ... > SQL Server follows the ANSI / ISO Standard behaviour for CHECK and FOREIGN ...
    (microsoft.public.sqlserver.programming)
  • Re: What is the limit to the size of a SQL statement...
    ... Cheers, Rob. ... > SQL Server MVP ... >>I have a very long SELECT statement with many WHERE clauses. ... >> MS SQL Server 2000. ...
    (microsoft.public.sqlserver.server)
  • RE: about Linked Servers
    ... Or you can try to change the four-part query to upper case ... linked Server queries with a four part name to access mixed-case tables in ... upper case letters, from SQL Server, such as: ...
    (microsoft.public.sqlserver.security)