How can I create a table from another table without copying
any values from the old table?
- 8 Answers
- 11285 Views
- I also Faced
- E-Mail Answers
Answer Posted / shabana
Use the describe command to display the table structure
then use the create table command and copy the table
structure in your command.
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
How to Execute a Package in PL/SQL.?
Show how functions and procedures are called in a pl/sql block.
What is blind sql injection?
What is the difference between a primary key and a clustered index?
List the ways to get the count of records in a table?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is identity column in sql server?
Why left join is used in sql?
What does (*) mean in sql?
Why use truncate instead of delete?
Why do we use partitions in sql?
How do we accept inputs from user during runtime?
Which sorts rows in sql?
How many parts of a pl sql block are optional?
What is nvarchar max in sql?
