CREATE a table from another table

Answer Posted / narendra

select *into newtable from oldtable.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of update statistics and scope_identity() function?

818


Explain acid?

800


what is a self join? : Sql server database administration

695


How the authentication mode can be changed?

846


Ms sql server index?

743






What is buffer cash and log cache in sql server?

799


What is the fastest way to permanently delete a 1 million row table named customers?

853


What is deploy, process and build? : sql server analysis services, ssas

749


How do I open a .db file?

732


Explain “row_number()” in sql server with an example?

721


Some queries related to SQL

738


How can I create a new template for import ? : sql server management studio

794


What is plan freezing?

724


What are different types of subquery?

908


How would you add a section to a table?

777