Post reply

Dynamic Schema Name

  • March 26, 2018 at 9:32 am

    #403208

    Hi,

     How to select from a table with dynamic schema name ? The database name and Table name remains constant . However the schema name will change .

    Thanks,

    PSB

  • March 26, 2018 at 10:49 am

    #1984564

    Sorry, but what is the question?  There is nothing in your post that even provides a clue what you are trying to accomplish.  We can't see what you see, nor can we read your mind.  You really need to provide more information if you want help.

  • March 27, 2018 at 10:56 am

    #1984682

    But, since it's fun to throw rocks down a well to hear them splash, you could just do this, without mentioning the schema at all.
    USE myDatabase;
    SELECT top 10 * FROM myTable;

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

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

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