You want to update the properties of the Suburb (name) column in the Address(employee) table of the temp database. This table is located in the Products schema. The column should now use the nvarchar(150) data type.

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: 4320 | Points: 40
Select from following answers:
  1. ALTER TABLE [Products].[employee] ALTER COLUMN name nvarchar(150)
  2. ALTER TABLE [employee].[ Products] ALTER COLUMN name nvarchar(150)
  3. ALTER COLUMN [Products].[employee].[name] nvarchar(150)
  4. All Above

Show Correct Answer

Source: | | Alert Moderator 

Comments or Responses

Login to post response