How can I bifurcate the tables regarding blank or having data SQL Server 2005

Question

0.00/5 (No votes)

See more:

Dear All,

Will any body tell me how can I bifurcate those tables in sql server 2005, which have data?

Is it possible to get the table names on such parameter!

Actually, I want to get table names with "Select * From Information.Schema.Tables" like query but for those tables which have data or which don't have data.

Pranav

Posted 26-Feb-11 2:16am

pranav82

Updated 26-Feb-11 2:48am

v2

Add a Solution

2 solutions

Solution 1

I think that you will need to be more specific about what you mean by 'bifurcate'.

My understanding is that it means 'to split into two' and is not a term that I normally associate with databases.

Do you mean that you want to redesign the database schema, or something else?

Posted 26-Feb-11 2:43am

Henry Minute

Comments

Yusuf 27-Feb-11 8:28am

using that term bothered me too.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Costica U · Accepted Answer · 2011-02-27T02:05:00

Do you want to select all tables that have rows? See How Many Records Are There in your Database?[^].

That would be:

SQL

SELECT SYS_OBJ.NAME AS "TABLE NAME"
     , SYS_INDX.ROWCNT AS "ROW COUNT"
FROM SYSOBJECTS SYS_OBJ, SYSINDEXES SYS_INDX
WHERE SYS_INDX.ID = SYS_OBJ.ID
  AND INDID IN(0,1) --This specifies 'user' databases only
  AND XTYPE = 'U' --This omits the diagrams table of the database
--You may find other system tables will need to be omitted,
 AND SYS_OBJ.NAME <> 'SYSDIAGRAMS'
AND SYS_INDX.ROWCNT > 0