Create table emp1 as select * from emp where 1=2 It will give the

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

Question Posted / karthik

Answer Posted / karthik

Create table emp1
as
select * from emp
where 1=2

It will give the structure of the table.

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Tell me when is the update_statistics command used?

1015

What are different types of schemas?

893

What are the new security features added in sql server 2012? : sql server security

947

Why are you getting errors when creating a new odbc dsn?

1165

Explain hostprotectionattribute in sql server 2005?

957

What is difference between clustered index and non clustered index?

1025

What is a filestream?

938

You want to implement the one-to-many relationship while designing tables. How would you do it?

909

what is denormalization? : Sql server database administration

876

How to convert binary strings into integers in ms sql server?

961

What is user-defined scalar function?

909

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1031

List the advantages of using stored procedures?

996

Why I can not enter 0.001 second in date and time literals in ms sql server?

1010

Explain nested join?

921