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

Answer Posted / anand.kv

SELECT TOP 0 * INTO tableB FROM tableA

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a performance monitor?

552


What is it’s similarity with sql server?

143


How to add additional conditions in SQL?

582


Explain “not null constraint” in sql server?

518


What are the 10 characteristics of data quality?

525






what is new philosophy for database devises for sql server 7.0? : Sql server database administration

512


What are rest-style architecture's?

149


Explain difference between cross join and full outer join?

554


How you can add messages to the nt event log from within a stored procedure?

563


What is the difference between for auto and for nested?

504


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1779


When does a workload on SQL Azure get throttled?

113


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1545


What are the different editions available in sql server 2000?

582


What do you understand by mirroring and mention the advantages of the mirroring?

572