What’s the distinction between dropping a info and taking a info offline?
- 1 Answers
- 1124 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rina Kumari
Dropping an object (e.g., table, view, stored procedure) permanently removes it from the database. On the other hand, taking an object offline makes it temporarily unavailable for queries or transactions but keeps the structure intact. Taking an object online makes it accessible again.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Where can you add custom error messages to sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How raid can influence database performance?
What is clustered index
How can you append an identity column to a temporary table?
Does view occupy space?
What is the difference between for xml raw and for xml auto?
How to enter binary string literals in ms sql server?
Can you index views?
Can we do dml on views?
How efficient you are in oracle and SQL server?
How do I find the sql server version?
What is a coalesce function?
Why we use the openxml clause?
