Post reply

sort only database table

  • December 18, 2010 at 11:11 am

    #72066

    hello

    My problem is i want to sort only user tables in database only i use SP_tables but it not work please send me

    query to sort only user tables not system tables

  • December 18, 2010 at 2:45 pm

    #1264400

    Don't understand what you're asking. Please clarify.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 18, 2010 at 2:58 pm

    #1264401

    I agree with Gila here, but seems that you want to see just the tables per database, if you want something like that, you can check with simple query:

    SELECT NAME, OBJECT_ID, CREATE_DATE FROM SYS.OBJECTS

    WHERE TYPE = 'U'

    ORDER BY NAME ASC

    Tell me if this is what you want!?!?!

    :w00t::hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply