Client Login Area
Main Menu
Results 1 to 4 of 4

Thread: List of database tables and stored procedures - MS SQL

  1. #1
    Verified Community Member seofast's Avatar
    Join Date
    July 2, 2010
    Posts
    22

    Default List of database tables and stored procedures - MS SQL

    Often times it comes handy if you can list database tables and stored procedures.

    ( i tried it with 2005 )
    List of tables in MS SQL
    select * from mydatabase.sys.tables

    List of stored procedures in MS SQL
    select * from mydatabase.sys.procedures

    replace mydatabase with your database name.

  2. #2
    Verified Community Member Shani's Avatar
    Join Date
    April 24, 2010
    Posts
    97

    Default

    I sometimes use it.

  3. #3
    Verified Community Member
    Join Date
    September 17, 2010
    Location
    US
    Posts
    6

    Default

    ofcourse.. with works fine with me also.

  4. #4
    ASPnix Administration Roma's Avatar
    Join Date
    June 27, 2005
    Location
    Denver, CO
    Posts
    4,066

    Default

    Quote Originally Posted by stevemack View Post
    ofcourse.. with works fine with me also.
    If you have some more samples that you like and use, please share!
    Roma
    Friendly ASPnix Administrator


    https://www.aspnix.com
    roma@aspnix.com



    ASPnix on Facebook

Posting Permissions

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