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 |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2007-12-18 : 04:27:46
|
| HiI want to know that which table of my DataBase have records(rows).My database have 200 tables and i do't want to open and check each tables i am using SQL server 2000.Ranjeet Kumar Singh |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-12-18 : 04:39:17
|
| [code]Select Object_Name(id),* From Sys.Sysindexes Where [Rows] <=0[/code]Chiraghttp://www.chirikworld.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-18 : 04:42:32
|
| A quick waySelect object_name(id) as table_name, rows from sysindexeswhere indid<2MadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-18 : 04:44:16
|
quote:
Originally posted by chiragkhabaria
Select Object_Name(id),* From Sys.Sysindexes Where [Rows] <=0 Chiraghttp://www.chirikworld.com
Why did you use [rows]<=0?MadhivananFailing to plan is Planning to fail |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-12-18 : 04:46:59
|
| OP told that he want the table name which has no records ..Chiraghttp://www.chirikworld.com |
|
|
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
Posted - 2007-12-18 : 04:49:46
|
| Thanks........Ranjeet Kumar Singh |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-18 : 04:50:59
|
quote:
Originally posted by ranjeetsingh_6
HiI want to know that which table of my DataBase have records(rows).My database have 200 tables and i do't want to open and check each tables i am using SQL server 2000.Ranjeet Kumar Singh
MadhivananFailing to plan is Planning to fail |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-12-18 : 04:53:50
|
| opps.. I guess it was my perception since, i thought OP wants to drop the rest of the tables..Chiraghttp://www.chirikworld.com |
|
|
|
|
|
|
Find that which table of database have records