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

How to enter unicode character string literals in ms sql server?

1064

What are the advantages dts has over bcp?

995

What are scalar functions in sql?

1138

What is raid? : SQL Server Architecture

1169

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1799

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

957

How and why use sql server?

997

What is sql profiler. What are the default templates with it? : sql server database administration

1026

Explain the dbcc pintable command when would you use it?

906

Explain the functionalities that views support?

1109

What is the maximum size per database for sql server express?

1040

Why do we use functions?

907

How to return the second 5 rows in ms sql server?

1053

How do you rename a table in sql server?

1013

What is normalization according to you and explain its different levels?

943