How can I obtain the list of tables in a database using SQLConnection?

<i><b>Originally posted by : Leo (leonahart@phreaker.net)</b></i><br />I don't know just how to get all of the table's names that are available in a SQL Server 2K database, help! Thnx in advance,<br />

sp_tables [ [ @table_name = ] 'name' ]
[ , [ @table_owner = ] 'owner' ]
[ , [ @table_qualifier = ] 'qualifier' ]
[ , [ @table_type = ] "type" ]

DECLARE @RC int
DECLARE @table_name nvarchar(384)
DECLARE @table_owner nvarchar(384)
DECLARE @table_qualifier nvarchar(128)
DECLARE @table_type varchar(100)
EXEC @RC = [master].[dbo].[sp_tables] @table_name, @table_owner, @table_qualifier, "'table'"