Which of the following statements is the correct syntax for adding a new column called Gender into a table called dbo.Contact that already contains data?
A. ALTER TABLE dbo.Contact ADD COLUMN Gender CHAR(1) NOT NULL
B. ALTER TABLE dbo.Contact ADD COLUMN Gender CHAR(1) NULL
C. ALTER TABLE dbo.Contact ADD Gender CHAR(1) NOT NULL
D. ALTER TABLE dbo.Contact ADD Gender CHAR(1) NULL
Answer:[D]
Highlight to find out the answer.
Wednesday, February 17, 2010
Add a new column to an existing table
at 9:03 PM
Labels: SQL Server, SQL Server Test, SQL Server Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment