create table table_name as select * from another

what command is used to create a table by copying the
structure of another table?

Question Posted / kunal sain

Answer Posted / kunal sain

create table table_name
as select * from another_table
where 1>2;

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Explain about Joins?

982

What do you understand by the denormalisation?

949

What is sql injection? How to protect against sql injection attack?

986

What is a fan-out query in SQL Azure?

121

What are system databases into sql server (2005/2008)?

993

How to modify the underlying query of an existing view?

982

What are the steps to follow to configure SQL*Net?

1026

How to retrieve error messages using odbc_errormsg()?

1044

Explain what is the difference between union and union all?

1002

What are the triggers in sql?

1094

how to overcome kernel isssues

1619

What is user-defined scalar function?

958

What is the difference between the application object and session object?

1059

What is difference between createstatement and preparedstatement?

1083

What’s the use of custom fields in report?

932