We are using Microsoft SQL 2017 for Database Administration. Please provide a de

Question

We are using Microsoft SQL 2017 for Database Administration. Please provide a detailed explanation. Thank you.  

19. In the schema module4schema_yourInitials, create a table named tblModule4 Column Name yourInitials containing the following columns Data TypeOther Requirements Identity, start at 100, increment by 1 integer not null varchar(150) nulls allowed PersonID PersonName PostalCode BirthDate Gender LastUpdated datetime not null UpdatedBy | varchar(6) nulls allowed date nulls allowed vhar(1) nulls allowed Default of getdate() Default of suser _sname() varchar(50) not null

Explanation / Answer

CREATE TABLE module4schema_yourInitials.tblModule4_yourInitials ( PersonID int NOT NULL ,PersonName varchar(150) NULL ,PostalCode varchar(6) NULL ,BirthDate date NULL ,Gender varchar(1) NULL ,LastUpdated datetime NOT NULL ,UpdatedBy varchar(50) NOT NULL );

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.