How create table structure only from tableA to TableB if
TableA have some data?

Answer Posted / mits

Create table newtablename
from oldtablename
where 1=2

Is This Answer Correct ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is view in sql?

557


What is the difference RDBMS and Graph Database?

625


Does windows server 2016 come with sql server?

497


what kind of lan types do you know? : Sql server database administration

512


What is the purpose of data source?

509






What are the grouping functions?

523


What are views used for?

614


 Explain what is sql override for a source taLle in a mapping?

569


What is the user of Primary key?

576


What are the various editions of sql server 2017 that are available in the market?

501


What is database isolation in sql server? : sql server database administration

562


What does REVERT do in SQL Server 2005?

551


explain how to create a new schema in a database? : Sql server database administration

576


What is a view and what are its advantages?

685


How you can change the database name in SQL SERVER?

663