programplug Logo




COPY TABLE IN SQL



If you want to copy the table from another table in same SQL server you can do it by using SQL SELECT statement to copy the table.
Here is the Syntax:

SELECT * INTO (destination_table) FROM (source_table) 
						
EXAMPLE:
SELECT * INTO hr_table FROM management_table;  
							

Remember:

SELECT INTO is totally different from INSERT INTO STATEMENT.






Our Services

Developing Cheapest Websites
Offer Digital Marketing
Provide College Projects
Attractive Website Developing
Summer Training,Industrial Training
SCO,SMO

Contact Us

Dehradun Uttarakhand India
www.programplug.com
info@programplug.com
08534019974
Designed By : Mridul Gupta

Other Link

About Us

Contact Us

Disclaimer

Privacy Policy