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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-11 : 08:13:41
|
| firdous writes "how to find no: of tables in a master or any database?to find no" of tables if i created a database?" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-11 : 10:10:15
|
| Hi firdous, Welcome to SQL Team!Will this do you?SELECT COUNT(*) FROM MyDatabase.INFORMATION_SCHEMA.TABLESKristen |
 |
|
|
|
|
|
sql server