How to a Query to copy data from on table to another table.

Answer Posted / rajdeep gupta

Hi there is a question copy only schema without data from
one table to another

INSERT INTO A1 select name,address from A2 WHERE 1 = 2

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what is sql profiler?

800


What languages bi uses to achieve the goal?

701


What is data modeling and Reterminal integrity?

1703


Explain the use of containers in ssis?

684


What are database states in ms sql server?

839


Is null vs coalesce?

647


What are the different types of subquery?

826


What is triggers and its types?

732


Explain an automatic checkpoint

725


Describe triggers features and limitations?

686


What is thr feature of change data capture?

680


Detail about query optimizer?

805


What happens if you are trying to access a schema not owned by you?

724


What is a synonym for manipulation?

734


When would you use it?

765