Results 1 to 3 of 3

Thread: List of all tables and size

  1. 10-01-2001, 09:47 AM #1
    Majo Guest

    List of all tables and size

    Does anybody know how to make a query that presents ALL
    tables and their sizes (in Kb or Mb) from a database?

    Is there a Stored Procedure for this purpose?

    Thanks

    Reply With Quote Reply With Quote
  2. 10-01-2001, 11:28 AM #2
    TimH Guest

    List of all tables and size (reply)

    Hi Majo,

    Take a look at the 'SQL scripts - Mainenance and Management' section on this site. It has several good examples of stored procedures to do this.

    Good luck,

    TimH


    ------------
    Majo at 10/1/01 10:47:10 AM

    Does anybody know how to make a query that presents ALL
    tables and their sizes (in Kb or Mb) from a database?

    Is there a Stored Procedure for this purpose?

    Thanks

    Reply With Quote Reply With Quote
  3. 10-01-2001, 12:58 PM #3
    Mohammed. Guest

    List of all tables and size (reply)

    sp_MSForEachTable 'EXEC sp_spaceused ''?''' ...

    Mohammed..

    ------------
    TimH at 10/1/01 12:28:54 PM

    Hi Majo,

    Take a look at the 'SQL scripts - Mainenance and Management' section on this site. It has several good examples of stored procedures to do this.

    Good luck,

    TimH


    ------------
    Majo at 10/1/01 10:47:10 AM

    Does anybody know how to make a query that presents ALL
    tables and their sizes (in Kb or Mb) from a database?

    Is there a Stored Procedure for this purpose?

    Thanks

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules