what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 15155 Views
- CMC, eicc, I also Faced
- E-Mail Answers
Answer Posted / anksuh
SELECT TOP 0 * INTO employee2 FROM dbo.employeedtls
using this command we can copying the structure of one table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is coalesce faster than isnull?
Explain locks? : Transact sql
Can we join two tables without common column?
What is a sql statement?
what is sp_pkeys? : Transact sql
Explain lock escalation? : Transact sql
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How do I access sql anywhere database?
What is rank function in sql?
What is package in pl sql with an examples?
Explain table and field in sql?
Why trigger is used in sql?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is varchar sql?
what are the security recommendations while using mysql? : Sql dba
