Re: user tables

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 07/13/04

Next message: pp: "Re: About mysql privilage table"
Previous message: Peter: "Re: Public Role in SQL Server 2000 SP3"
In reply to: hari: "user tables"
Next in thread: anonymous_at_discussions.microsoft.com: "Re: user tables"
Reply: anonymous_at_discussions.microsoft.com: "Re: user tables"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 13 Jul 2004 00:53:55 -0400

> What's wrong with the query?

You're querying system tables directly?

> I want to get the list of
> ONLY user tables in the database.

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE
OBJECTPROPERTY(OBJECT_ID(TABLE_SCHEMA+'.'+TABLE_NAME), 'IsMsShipped') = 0

-- 
http://www.aspfaq.com/
(Reverse address to reply.)

Next message: pp: "Re: About mysql privilage table"
Previous message: Peter: "Re: Public Role in SQL Server 2000 SP3"
In reply to: hari: "user tables"
Next in thread: anonymous_at_discussions.microsoft.com: "Re: user tables"
Reply: anonymous_at_discussions.microsoft.com: "Re: user tables"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Building SQL Query to fill a treeview control with Year->Month->Day nodes
... >> You could simply write a query that does a join with a calendar table. ... >> (Reverse address to reply.) ... >>> I have load dates for each row in my database table. ... >>> I'm trying to load a treeview control with the results like so. ...
(microsoft.public.sqlserver.server)
Re: Building SQL Query to fill a treeview control with Year->Month->Day nodes
... >> You could simply write a query that does a join with a calendar table. ... >> (Reverse address to reply.) ... >>> I have load dates for each row in my database table. ... >>> I'm trying to load a treeview control with the results like so. ...
(microsoft.public.dotnet.framework.windowsforms.controls)
Re: Building SQL Query to fill a treeview control with Year->Month->Day nodes
... >> You could simply write a query that does a join with a calendar table. ... >> (Reverse address to reply.) ... >>> I have load dates for each row in my database table. ... >>> I'm trying to load a treeview control with the results like so. ...
(microsoft.public.sqlserver.xml)
Re: Building SQL Query to fill a treeview control with Year->Month->Day nodes
... >> You could simply write a query that does a join with a calendar table. ... >> (Reverse address to reply.) ... >>> I have load dates for each row in my database table. ... >>> I'm trying to load a treeview control with the results like so. ...
(microsoft.public.sqlserver.msde)
Re: DBMS and lisp, etc.
... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
(comp.lang.lisp)