Answer Posted / manoj savalia

Try This

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)
AND XTYPE = 'U'
AND SYS_OBJ.NAME <> 'SYSDIAGRAMS'
AND SYS_INDX.ROWCNT>0
ORDER BY SYS_INDX.rowcnt DESC

What are the different types of columns types constraints in the sql server?

1008

---

What is the architecture of ms sql reporting service?

920

---

Can you pass expressions to function parameters?

1031

---

How to write a query with an inner join in ms sql server?

997

---

Define msdb database?

973

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1011

---

What is difference between views and stored procedures?

928

---

what are defaults? : Sql server database administration

1005

---

Explain the different types of backups available in sql server? : sql server database administration

863

---

Name 3 ways to get an accurate count of the number of records in a table?

965

---

Can a rule be bound to any column of any data type?

911

---

What are the dis_advantages of stored procedures, triggers, indexes?

2171

---

How can sql server instances be hidden?

894

---

How to insert data with null values?

970

---

What is meant by referential integrity?

957

---