Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Script --- View tables in database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-14 : 08:38:49
Chris writes "Hey MySQL Team,

I need a script that will look in a certain database and list me all the table names inside that database. I just need the names no other information about the tables.

Thanks,

Chris
CDC System Engineer"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-02-14 : 08:46:31
Will this article get you started?

http://www.sqlteam.com/item.asp?ItemID=7269

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

childsce
Starting Member

4 Posts

Posted - 2007-02-14 : 09:40:06
I figured it out. I used select * from information_schema.tables
Go to Top of Page
   

- Advertisement -