Re: How to get table list from a db? Thanks!


Hi, you can write it as:

SELECT name [Table Name]
FROM sysobjects
WHERE xtype = 'U'

Please let me know if this helped

best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Ansi Nulls and quoted identified
    ... FROM sysobjects WHERE xtype IN ... ALTER PROCEDURE / ALTER VIEW / ALTER FUNCTION. ... lucky today, as to change an undocumented column in a system table), I ...
    (comp.databases.ms-sqlserver)
  • Re: Passed 70-305
    ... afford them.I am planning to give the exam in nera future. ... Chandra wrote: ... > Best Regards, ...
    (microsoft.public.cert.exam.mcad)
  • Re: Drop system table?
    ... I assume the table in question was change to xtype 'S' by hacking the ... sysobjects table. ... EXEC sp_configure 'allow',1 ... How can I get rid of it? ...
    (microsoft.public.sqlserver.server)
  • SQL Server Bug: Using scalar functions within a subquery ON Clause
    ... I've been working around this bug for a long time now, ... to report bugs on their site, I will post this here and hopefully somone will ... IF EXISTS(SELECT * FROM sysobjects WHERE name = 'Lookup_MaxSales' and xtype ...
    (microsoft.public.sqlserver.server)
  • RE: looking for ways to list publication object please help
    ... select name from sysobjects ... where id not in (select objid from sysarticles) ... and xtype = 'U' ...
    (microsoft.public.sqlserver.replication)