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 a default tcp/ip socket assigned for sql server? : Sql server database administration

1073

What is 1nf normalization form?

1035

How to create dbo table in sql server?

954

What is PROJECTION Operation?

1022

What is rs.exe utility?

156

Differentiate between truncate vs delete in mssql?

1085

What is the maximum size of column in sql server?

893

Explain different backup plans?

946

What does it mean to normalize a database and why would you do it?

979

What is an indexing technique?

936

Explain log shipping?

1020

What is the difference between varchar and varchar types?

1071

Difference between group by clause and having clause in SQL?

972

What is the native system stored procedure to execute a command against all databases?

1030

What is transact-sql ddl trigger?

1107