user tables

From: hari (anonymous_at_discussions.microsoft.com)
Date: 07/13/04 

Date: Mon, 12 Jul 2004 21:48:27 -0700

Hi,

When I execute the following query, I'm
getting 'dtproperties' table also.

SELECT name FROM SYSOBJECTS WHERE XTYPE = 'U'

But when I list tables in EM, the type of 'dtproperties'
table is shown as 'System'.

What's wrong with the query? I want to get the list of
ONLY user tables in the database.

Thanks,
Hari

Relevant Pages

  • Re: Dynamically Copy Data
    ... declare @table_name varchar ... SELECT name FROM sysobjects where xtype = 'u' and name ...
    (microsoft.public.sqlserver.dts)
  • Re: Reformat Group membership table
    ... CROSS JOIN sysobjects s2 ... I would like to run SQL queries that returns a result set which has all ... believe I can do this effectively is to reformat the table to a format ... I'm looking for suggestions on how I can accomplish my SQL query... ...
    (microsoft.public.sqlserver.programming)
  • select no. of rows from the current database
    ... the result of the query is (depending of the database): ... But when I count the number of rows of "sysobjects", ...
    (comp.databases.ms-sqlserver)
  • Re: Insert to temporary table causes EXCEPTION_ACCESS_VIOLATION
    ... Running this script ... SP from Query Analyzer if the SP dies ... your check for xtype is ... What other kind of object is going to be named #ChangeLogs and ...
    (microsoft.public.sqlserver.server)
  • Re: Help convert an Oracle select on indexes to MSSQL...?
    ... For the second query it was actually a simplification to put each ... index column on its own row. ... FROM sysobjects o ... JOIN sysindexes i ON i.id = o.id ...
    (comp.databases.ms-sqlserver)