SQL Select INTO Query

Question

I am trying to running the following command to copy a table to another database and it is saying incorrect syntax near "tbl_SecurityNamespace". Any ideas? TIA

select * into ForMSDB  tbl_SecurityNamespace
from Tfs_configuration  
go

what technology is this? SQL Server? The ForMSDB looks incorrect unless that is the DB name, then if it is SQL Server it should be ForMSDB.dbo.tbl_SecurityNamespace — Brad, May 02 '18 at 18:40
Possible duplicate of [Copy tables from one database to another in SQL Server](https://stackoverflow.com/questions/187770/copy-tables-from-one-database-to-another-in-sql-server) — ventsyv, May 02 '18 at 18:41

score 2 · Answer 1 · answered May 02 '18 at 18:40

2

If it's another database in the same environment:

select * into ForMSDB..tbl_SecurityNamespace
from Tfs_configuration

answered May 02 '18 at 18:40

Daniel Marcus

2,686
1
7
13

Yogesh Sharma · Accepted Answer · 2018-05-02T18:41:24.550

1

This should be as

select * into ForMSDB..tbl_SecurityNamespace
from Tfs_configuration;

edited May 02 '18 at 18:41

answered May 02 '18 at 18:39

Yogesh Sharma

49,870
5
26
52

1

I'm doubting this since the user specified "another database"... and ForMSDB sounds an awful lot like the name of another database... – Jacob H May 02 '18 at 18:40
thank you now the error is Invalid object name 'Tfs_configuration'. – user1342164 May 02 '18 at 18:41
1

Then you are missing that table or you are not pulling from the correct db - or its in another schema that you need to specify – Daniel Marcus May 02 '18 at 18:42

SQL Select INTO Query

2 Answers2