Sql server query
i want to create a table with the same data as old table and schema but with different name
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jitendra KumarPosted Jan 21, 2015, 3:50 AM
Try this :-
SELECT * INTO NewtableName FROM OldTableName
Ex :- SELECT * INTO tbl_Emp1 FROM tbl_Emp
Khargesh RajputPosted Jan 21, 2015, 3:33 AM
select specific database object> choose your table>
next>click on advance>general>types of data to script>dropdown choose >Schema and data
>ok>next >finish>
run script to database and rename the tablename