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: 3925 | Points: 40
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: | | Alert Moderator 

Comments or Responses

Login to post response