what command is used to create a table by copying the
structure of another table?
Answer Posted / narsing
SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Can group functions be mixed with non-group selection fields in ms sql server?
What is a trigger and types of a trigger?
Where are sql server usernames and passwords stored in the sql server?
How to write an inner join with the where clause in ms sql server?
Define views.
Can a trigger be created on a view?
When cursors are useful?
What is plan freezing?
Explain logical operators in sql server?
What is format parameter in ssrs?
What is function of CUBE ?
Can a table have 2 primary keys?
How do I port a number to sql server?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How to get the definition of a stored procedure back?