You can also use the sysObjects table
select * from sysobjects where xtype = 'u'
>Dear All,
>How to get a list of Tables in Ms. SQL Server database using VB.NET? ..
>
>Thanks
>
>Winanjaya
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com