"clintonG" <csgallagher@REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:u%23BUxkagEHA.3864@TK2MSFTNGP10.phx.gbl...
> I have created a table with many columns that needs to be duplicated
> within the same database where the duplicate table can then be modified.
>
> The context menu in the Enterprise Manager enables a copy selection
> but then there is no paste. Using Query Analyzer I tried the following...
>
> SELECT *
> INSERT TargetTable
> FROM SourceTable
>
> ... producing results that state the table has been created but the new
> table can not be seen when returning to the Enterprise Manager.
>
> Can somebody explain how to get this done?
>
> --
> <%= Clinton Gallagher, "Twice the Results -- Half the Cost"
> Architectural & e-Business Consulting -- Software Development
> NET csgallagher@REMOVETHISTEXTmetromilwaukee.com
> URL http://www.metromilwaukee.com/clintongallagher/
>
>
>

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:%23EevJIbgEHA.3428@TK2MSFTNGP11.phx.gbl...
> I assume there is a typo in your post and you used SELECT ... INTO:
>
> SELECT *
> INTO TargetTable
> FROM SourceTable
>
> You might try refreshing the table list in Enterprise Manager.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "clintonG" <csgallagher@REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:u%23BUxkagEHA.3864@TK2MSFTNGP10.phx.gbl...
> > I have created a table with many columns that needs to be duplicated
> > within the same database where the duplicate table can then be modified.
> >
> > The context menu in the Enterprise Manager enables a copy selection
> > but then there is no paste. Using Query Analyzer I tried the
following...
> >
> > SELECT *
> > INSERT TargetTable
> > FROM SourceTable
> >
> > ... producing results that state the table has been created but the new
> > table can not be seen when returning to the Enterprise Manager.
> >
> > Can somebody explain how to get this done?
> >
> > --
> > <%= Clinton Gallagher, "Twice the Results -- Half the Cost"
> > Architectural & e-Business Consulting -- Software Development
> > NET csgallagher@REMOVETHISTEXTmetromilwaukee.com
> > URL http://www.metromilwaukee.com/clintongallagher/
> >
> >
> >
>
>

"Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
news:%23QLNjhcgEHA.1276@TK2MSFTNGP09.phx.gbl...
>
> >SELECT *
> >INSERT TargetTable
> >FROM SourceTable
>
> This statement will give you a syntax Error only.
> To copy the structure and data use
>
>
> SELECT *
> INTO TargetTable
> FROM SourceTable
>
> The table will be created as current user as the owner.
> If you want to create it int he dbo's context use
>
> SELECT *
> INTO dbo.TargetTable
> FROM SourceTable
>
> If you just want the structure and not data add a condition like
>
> SELECT *
> INTO TargetTable
> FROM SourceTable
> WHERE 1=0
>
> --
> Roji. P. Thomas
> Net Asset Management
> https://www.netassetmanagement.com
>
>
> "clintonG" <csgallagher@REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:u%23BUxkagEHA.3864@TK2MSFTNGP10.phx.gbl...
> > I have created a table with many columns that needs to be duplicated
> > within the same database where the duplicate table can then be modified.
> >
> > The context menu in the Enterprise Manager enables a copy selection
> > but then there is no paste. Using Query Analyzer I tried the
following...
> >
> > SELECT *
> > INSERT TargetTable
> > FROM SourceTable
> >
> > ... producing results that state the table has been created but the new
> > table can not be seen when returning to the Enterprise Manager.
> >
> > Can somebody explain how to get this done?
> >
> > --
> > <%= Clinton Gallagher, "Twice the Results -- Half the Cost"
> > Architectural & e-Business Consulting -- Software Development
> > NET csgallagher@REMOVETHISTEXTmetromilwaukee.com
> > URL http://www.metromilwaukee.com/clintongallagher/
> >
> >
> >
>
>

>SELECT *
>INSERT TargetTable
>FROM SourceTable

"clintonG" <csgallagher@REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:u%23BUxkagEHA.3864@TK2MSFTNGP10.phx.gbl...
> I have created a table with many columns that needs to be duplicated
> within the same database where the duplicate table can then be modified.
>
> The context menu in the Enterprise Manager enables a copy selection
> but then there is no paste. Using Query Analyzer I tried the following...
>
> SELECT *
> INSERT TargetTable
> FROM SourceTable
>
> ... producing results that state the table has been created but the new
> table can not be seen when returning to the Enterprise Manager.
>
> Can somebody explain how to get this done?
>
> --
> <%= Clinton Gallagher, "Twice the Results -- Half the Cost"
> Architectural & e-Business Consulting -- Software Development
> NET csgallagher@REMOVETHISTEXTmetromilwaukee.com
> URL http://www.metromilwaukee.com/clintongallagher/
>
>
>

> close and restart Enterprise Manager which I should have tried
> before posting.