all tables in database - SQL Server Forums

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)

all tables in database

Author

Topic

pamit_1982
Starting Member

13 Posts

Posted - 2007-05-10 : 10:33:50

Hi guys!1

How to find all tables in database.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-10 : 10:37:17

query on sysobjects or information_schema.tables

If you are new to MS SQL Server, search for "Learn SQL" here

Madhivanan

Failing to plan is Planning to fail

pamit_1982
Starting Member

13 Posts

Posted - 2007-05-10 : 10:38:38

Thanks Madhiv

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-10 : 10:41:12

quote:
Originally posted by pamit_1982

Thanks Madhiv

Dont truncate my name

Madhivanan

Failing to plan is Planning to fail

sshelper
Posting Yak Master

216 Posts

Posted - 2007-05-10 : 10:57:51

You can also use the sp_tables system stored procedure, which will also give you system tables and views in addition to user tables.

SQL Server Helper
http://www.sql-server-helper.com

Kristen
Test

22859 Posts

Posted - 2007-05-10 : 14:05:14

"If you are new to MS SQL Server, search for "Learn SQL" here"

Or here

:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Learning+SQL

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-11 : 04:54:05

quote:
Originally posted by Kristen

"If you are new to MS SQL Server, search for "Learn SQL" here"

Or here :

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Learning+SQL

Thanks. I didnt know if you added those

"Search here " also means search in Kristen's FAQ

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources