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 happens if you add a new index to large table?

682


Explain differences between web edition and business edition?

115


What is the difference RDBMS and Graph Database?

807


How do you create an execution plan?

665


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

785


What are unicode character string data types in ms sql server?

809


Is mysql the same as sql server?

685


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

806


What is the need for indexing?

665


What is the default server name for sql server?

806


What are subqueries in sql server?

796


What is the syntax to execute the sys.dm_db_missing_index_details?

744


Detail about query optimizer?

801


How do I debug a stored procedure in sql server?

731


What is a trigger and types of a trigger?

745