Re: Views Show Up in SQL Server Tables List
- From: "Kalen Delaney" <replies@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 08:46:40 -0800
There should not be views there and I am not able to reproduce this.
Can you verify that the objects are views? Open a query window and run
EXEC sp_help object_name
The first line of output will tell you what kind of object you are dealing
with.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"MarkGsch" <markgsch@xxxxxxxxxxxxxxx> wrote in message
news:71A4F7C0-0272-43F1-BCB2-E51B27DD5BBC@xxxxxxxxxxxxxxxx
> Kalen, in the object explorer window (left pane) of the management studio,
> under the server name node, under 'Databases', under the database name,
> under
> 'Tables', the list of tables for the one database I started migrating...in
> addition to tables there are views.
>
> "Kalen Delaney" wrote:
>
>>
>> The code I gave was to filter using a TSQL statement. If you are using a
>> GUI, you're own your own.
>>
>> What "tables list" in the GUI are you referring to? When I go to Object
>> Explorer in SQL 2005, and expand the tables node under one of my user
>> databases, I only see tables, not views.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.solidqualitylearning.com
>>
>>
>> "MarkGsch" <markgsch@xxxxxxxxxxxxxxx> wrote in message
>> news:905E3C0D-179E-4F70-9171-A800CB59F388@xxxxxxxxxxxxxxxx
>> > Kalen, I am using the release version of the SQL Server 2005 'SQL
>> > Server
>> > Management Studio'. It is the 64-bit version, running on Win 2003
>> > Server
>> > 64-bit. Here is some specific version information:
>> >
>> > Microsoft SQL Server Management Studio 9.00.1399.00
>> > Microsoft Analysis Services Client Tools 2005.090.1399.00
>> > Microsoft Data Access Components (MDAC) 2000.086.1830.00
>> > (srv03_sp1_rtm.050324-1447)
>> > Microsoft MSXML 2.6 3.0 6.0
>> > Microsoft Internet Explorer 6.0.3790.1830
>> > Microsoft .NET Framework 2.0.50727.42
>> > Operating System 5.2.3790
>> >
>> > I am not sure how to do the filter you mention in the Object Explorer
>> > Filter. Thanks.
>> >
>> > "Kalen Delaney" wrote:
>> >
>> >>
>> >> Hi Mark
>> >>
>> >> How are you looking at the 'tables list'? There are lots of ways to
>> >> get
>> >> lists of objects. Are you using a SQL command or a GUI?
>> >> What version are you running?
>> >>
>> >> If you are using INFORMATION_SCHEMA.tables, you will note that the
>> >> last
>> >> column is 'table_type' and contains the values 'BASE TABLE' and
>> >> 'VIEW'.
>> >> So you can filter out the views:
>> >>
>> >> SELECT table_name
>> >> FROM INFORMATION_SCHEMA.tables
>> >> WHERE table_type = 'BASE TABLE'
>> >>
>> >> --
>> >> HTH
>> >> Kalen Delaney, SQL Server MVP
>> >> www.solidqualitylearning.com
>> >>
>> >>
>> >> "MarkGsch" <markgsch@xxxxxxxxxxxxxxx> wrote in message
>> >> news:3CECA223-5062-4FED-A43D-08987556AF28@xxxxxxxxxxxxxxxx
>> >> > How do I get them out ? Thanks.
>> >> >
>> >>
>> >>
>> >>
>> >>
>> >
>>
>>
>>
>>
>
.
- References:
- Re: Views Show Up in SQL Server Tables List
- From: Kalen Delaney
- Re: Views Show Up in SQL Server Tables List
- From: Kalen Delaney
- Re: Views Show Up in SQL Server Tables List
- From: MarkGsch
- Re: Views Show Up in SQL Server Tables List
- Prev by Date: Re: Views Show Up in SQL Server Tables List
- Previous by thread: Re: Views Show Up in SQL Server Tables List
- Next by thread: Stored Procedure Schema not retrieved
- Index(es):
Relevant Pages
|
Loading
