create table sunil as select *from hr.employees

How can I create a table from another table without copying
any values from the old table?

Question Posted / sunil panghal

Answer Posted / sunil panghal

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How will you distinguish a global variable with a local variable in pl/sql?

1158

What is dml and ddl?

970

How do you rename a table in sql?

1124

What does inner join mean?

1181

What are tables and fields?

1044

What are the two parts of design view?

1023

how is myisam table stored? : Sql dba

1064

How is indexing done in search engines?

985

How do I truncate a sql log file?

1080

What is hibernate and its relation to sql?

1131

What is difference between rank () row_number () and dense_rank () in sql?

1113

How do I save a sql query?

1021

What are dml commands?

1026

What is sqlservr exe?

986

Why procedure is used in sql?

1045