Question: USING MICROSOFT SQL SERVER MANAGEMENT STUDIO I've done numbers 3 and 4 but am having trouble with number 12 can someone please help me with

USING MICROSOFT SQL SERVER MANAGEMENT STUDIO
I've done numbers 3 and 4 but am having trouble with number 12 can someone please help me with the T_SQL query please
3) Create a new schema named CustomerService with owner of dbo.
4) Create a new filegroup in the AdventureWorks2014 DB containing one file name the filegroup AD_CustomerService and file whatever you wish, but use standard naming convention for the suffix.
12) Create a new CLUSTERED table named CustomerService.Attachments on the newly created Filegroup with the following columns and properties:
a. Column called AttachmentID that is the primary key and an ever-increasing unique integer (use Identity property and make this the primary clustered key)
b. Column called ContactID that is integer and must exist in the CustomerService.Contacts table, if populated (enforce with referential integrity with the ContactID column in the Contacts table and nulls are not allowed)
c. Column called AttachmentDateTime of type datetime and not null
d. Column AttachmentName, that is a variable length character with a maximum length of 50 with nulls NOT allowed.
e. Column called Attachment that is a variable length binary column with a maximum length of MAX and nulls are not allowed.
f. Table should be compressed at the page level
g. ($$)DELIVERABLE COPY THE T_SQL TO CREATE THE ABOVE TABLE BELOW:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!