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

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 07/26/04 

Date: Sun, 25 Jul 2004 18:35:28 -0700

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: Adding a new field to a table.
    ... > I'm going to upgrade a SQL Server 2000 database table with a new column. ...
    (microsoft.public.sqlserver.programming)
  • Re: how to make all Updates Inserts in the database Upper case?
    ... of the database table, stored procs and application, it would take me a long ... when i set would force all the data comming in to Upper case. ... > converts all the input data to upper case, and then passes to the database. ... > I have a Sql server 2000 database which is already in production. ...
    (microsoft.public.sqlserver.server)
  • Re: How to store connection string in congif file
    ... In web.Config you have an <appSettings> section. ... HTH. ... > I am using SQL Server as a Database in my ASP.NET application. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Search column names in all user tables
    ... Cristian Babu ... > column names of all user tables of a SQL Server 2K database? ...
    (microsoft.public.sqlserver.programming)