[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

retrive user defined tables from a database

kishoreraman

3/9/2007 6:41:00 AM

Can any one tell me, how to display only user defined tables from a database.

for eg:) if you give,
Select * from sysobject from table_type='U' will display all the tables, which includes system table too.

Now i need to display only user created tables only, wats the query for it.

Please help me

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.egghe...
5 Answers

Adi Cohn

3/9/2007 7:12:00 AM

0

On Mar 9, 8:41 am, kishore raman wrote:
> Can any one tell me, how to display only user defined tables from a database.
>
> for eg:) if you give,
> Select * from sysobject from table_type='U' will display all the tables, which includes system table too.
>
> Now i need to display only user created tables only, wats the query for it.
>
> Please help me
>
> EggHeadCafe.com - .NET Developer Portal of Choicehttp://www.egghe...

You can use the objectproperty function:
select name from sysobjects where type = 'u' and objectproperty(id,
'IsSystemTable') = 0

Adi

johnty

10/24/2011 8:40:00 AM

0

On Oct 21, 11:29 pm, frschoonover <frschoono...@yahoo.com> wrote:
>
> None of us in this group care about what Chuck Berry did/does in his
> personal life.


When were you elected as this group's spokesman?

Please note you do not speak on my behalf and you have no clue about
my opinions or cares unless I tell you.


Fuck off. Sincerely.

Lisi Peteras

10/24/2011 9:51:00 AM

0

On 10/24/2011 4:39 AM, johnty wrote:
> On Oct 21, 11:29 pm, frschoonover<frschoono...@yahoo.com> wrote:
>>
>> None of us in this group care about what Chuck Berry did/does in his
>> personal life.
>
>
> When were you elected as this group's spokesman?
>
> Please note you do not speak on my behalf and you have no clue about
> my opinions or cares unless I tell you.
>
>
> Fuck off. Sincerely.

Well stated. The Schoonover does this in every group he invades. He has
been kicked out of so many news groups it is beyond belief. He
completely destroys threads. Worse is when he tries to hard sell his
message of the day which is that gay people like him can be cured by the
bible and turned into heteros.

It turned The Schoonover into a bible quoting virgin.

Meanwhile he still worships feet and he is still looking for men "to
connect with" and he is still an annoying freak.

Mack A. Damia

10/24/2011 1:01:00 PM

0

On Mon, 24 Oct 2011 05:51:06 -0400, Lisi Peteras
<nospam@nichtspam.com> wrote:

>On 10/24/2011 4:39 AM, johnty wrote:
>> On Oct 21, 11:29 pm, frschoonover<frschoono...@yahoo.com> wrote:
>>>
>>> None of us in this group care about what Chuck Berry did/does in his
>>> personal life.
>>
>>
>> When were you elected as this group's spokesman?
>>
>> Please note you do not speak on my behalf and you have no clue about
>> my opinions or cares unless I tell you.
>>
>>
>> Fuck off. Sincerely.
>
>Well stated. The Schoonover does this in every group he invades. He has
>been kicked out of so many news groups it is beyond belief. He
>completely destroys threads. Worse is when he tries to hard sell his
>message of the day which is that gay people like him can be cured by the
>bible and turned into heteros.
>
>It turned The Schoonover into a bible quoting virgin.
>
>Meanwhile he still worships feet and he is still looking for men "to
>connect with" and he is still an annoying freak.

I haven't observed any of the subjects you mention in thios newsgroup.

You're the one who keeps mentioning "worshipping feet". It's actually
an obssession with you if you check your past posts.

Lick any good toe jam lately. Ever spread it on toast?




moonpie

10/24/2011 1:57:00 PM

0

On Sat, 22 Oct 2011 15:03:43 -0700 (PDT), frschoonover
<frschoonover@yahoo.com> wrote:


>Please do us all in this group a favor and STOP bringing up what Chuck
>Berry did/does in his personal life. We would really appreciate that
>as we DO NOT care about what he did/does in his personal life. That is
>his business and none of ours.
>

but everything John and especially Yoko did/do in their personal lives
is OK?

Frank, you cant tell people what they can, and cannot talk about in
here.