Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You want to remove the price column of the product table. This table is located in the Category schema of the temp datatabase.
Which of the following statements can you use to accomplish this goal?
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 3996 |
Select from following answers:
ALTER TABLE [category].[ product] DROP COLUMN price
DROP COLUMN [category].[product] Odomete price
DROP COLUMN [product].[ Category] price
You can only use the DROP COLUMN statement from within the ALTER TABLE statement.
Show Correct Answer
measureup.com | |
< Previous :
You are reviewing a database created by a develope ...
Next > :
You want to update the properties of the Suburb (n ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
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 ...
What is J.W.T ?
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?