Re: Get List of Table names in database

From: Uri Dimant (urid_at_iscar.co.il)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 15:55:51 +0200

Hi
SELECT t1.name
FROM sysobjects t1
INNER JOIN sysindexes t2
ON t1.id = t2.id
WHERE t2.indid <= 1
AND t2.rows > 0
AND OBJECTPROPERTY(t1.id,'IsUserTable') = 1

<msnews@microsoft.com> wrote in message
news:%23WH9MQv0EHA.3820@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Please let me know the query to list all the table names in a given
database
> in sql server 2005.
>
>
>
> Best Regards
> Raghu
>
>
>