How create table structure only from tableA to TableB if
TableA have some data?
Answer Posted / mits
Create table newtablename
from oldtablename
where 1=2
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Why use view instead of a table?
Please differentiate between a local and a global temporary table?
What are the grouping functions?
What happens if the update subquery returns no rows in ms sql server?
Explain syntax for viewing, dropping and disabling triggers?
Explain the properties of sub-query in 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 define and use table alias names in ms sql server?
What is the command to change the recovery model?
What is difference in performance between insert top (n) into table and using top with insert?
Explain what is the purpose of sql profiler in sql server?
Why use cursor in sql server?
Explain primary key, foreign key and unique key?
How can we use ConnectorJ JDBC Driver with MS SQL?
Define views.