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

What is the advantage of sql server?

1079

What is msdb database? : SQL Server Architecture

1197

What are the steps you must follow to hide sql server instances?

1023

What are Row versions of DataRow?

1080

What is oltp (online transaction processing)?

1057

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1183

Explain about link server in sql server?

1113

How to add the custom code in Report?

129

Can we write trigger for view?

1067

Can a unique index be created on a column, which contains null?

966

What is explicit cursors?

1123

What is sql view?

1117

Tell me what do you understand by a view? What does the with check option clause for a view do?

1060

What are null values in ms sql server?

1141

what is the difference between openrowset and openquery?

1155