Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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?
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 4027 |
Select from following answers:
ALTER TABLE [category].[product] [category].[employee]
EXEC sp_rename category.product', 'employee'
EXEC sp_rename 'category.employee', ‘product’
You cannot use the ALTER TABLE statement to rename a table.
Show Correct Answer
measureup.com | |
< Previous :
Which of the following statements would you use to ...
Next > :
You want to remove the price column of the product ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You want to remove the price column of the product table. This table i ...
You want to update the properties of the Suburb (name) column in the A ...
You want to alter the properties of the city column of the employee ta ...
You want to add a new column to an existing table in the temp database ...
Which of the following Transact-SQL statements can you use to move a t ...
Which of the following Transact-SQL statements moves the product table ...
You want to create a new table, named TestTable, in the temp database. ...
You are creating a number of tables for your product database. You wan ...
Latest Interview Questions
In.Net which is the parent class to create all windows service?
What is infonomics?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?
How can you detect the servername ?
How can you detect the host name and Ip address?
How can you detect the version properties?