Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 878
Home > Interviews > Sql Server >

You are reviewing a database created by a developer. You have noticed that the developer has misnamed the product table in the category schema as employee. You need to change the employee table name to product.

Which of the following Transact-SQL statements can you use to accomplish this goal?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 4904 | Points: 40
Post | Interview FAQs | Exclusive Questions | Interview Home  
Select from following answers:
  1. ALTER TABLE [category].[product] [category].[employee]
  2. EXEC sp_rename category.product', 'employee'
  3. EXEC sp_rename 'category.employee', ‘product’
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Bookmark It

Comments or Responses

Login to post response

More Interview Questions by Rajkatie


Latest Interview Questions