Top

Database

41.

How can you create an empty table from an existing table?

Ans:

An example will be:

Select * into studentcopy from student where 1=2

Here, we are copying the student table to another table with the same structure with no rows copied.

Loading…
Tags: Database Interview Questions and Answers || Database Sort Questions and Answers || Database Detailed Questions and Answers || Database Tutorial