How to count all the rows in a table (Enterprise Manager)

To count all the rows in a table

1. Start the query by adding the table you want to summarize to the Diagram pane.
2. Right-click anywhere in the Diagram, Grid, or SQL panes, and choose Group By. The Query Designer adds a Group By column to the grid in the Grid pane.
3. Check * (All Columns) in the input source window for the table.

   The Query Designer automatically fills the term Count into the Group By column in the Grid pane and assigns a column alias to the column you are summarizing to create a useful column heading in query output. For more details, see Creating Column Aliases.