Post reply

cloning a table schema

  • April 9, 2006 at 11:33 am

    #171840

    hiya,

    I have a table tblDelivery

    I want to copy this table and rename it tblReturn

    I thought that I could script the table and replace all the values of "tblDelivery" with "tblReturn"

    However, I get an error saying "could not find tblReturn stored procedure"

     

    any ideas?

    cheers,

    yogi

  • April 9, 2006 at 4:06 pm

    #631643

    Quickest way, without indexes or scripting is

    SELECT * INTO tblReturn FROM tblDelivery WHERE 1=0

    not sure why you are getting the error you mention. If you are doing a search/replace is it possible that you are highlighting a tblReturn and therefore SQL Query Analyser thinks that you just want to run tblReturn?

    LinkedIn Profile

  • April 10, 2006 at 2:29 am

    #631667

    cheers David,

    I'll try that when I get home to my machine.

     

    yogi

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

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