Question: Execute the following query: USE sample; DROP TABLE employee; CREATE TABLE employee (emp_no INTEGER NOT NULL, emp_fname CHAR(20) NOT NULL, emp_Iname CHAR(20) NOT NULL, dept_no
Execute the following query: USE sample; DROP TABLE employee; CREATE TABLE employee (emp_no INTEGER NOT NULL, emp_fname CHAR(20) NOT NULL, emp_Iname CHAR(20) NOT NULL, dept_no CHAR NULL, CONSTRAINT prim_emplpRIMARY KEY (emp_no) ); Object Explorer qX Connect localhost (SQL Server 15.0.2000.5 - DESKTOP-2TI4ME8\\pdeka) Databases + System Databases Database Snapshots AdventureWorks2017 sample Database Diagrams Tables System Tables + FileTables External Tables Graph Tables dbo.department Hidbo.employee Columns wo emp_no (PK, int, not null) emp_fname (char(20), not null) emp_Iname (char(20), not null) E dept_no (char(1), null) Keys Constraints Triggers Indexes Statistics + dbo.project + dbo.projects + dbo.works_on Questions you can answer for submission: Technical: What is the command for? Why would you use the command? Application: What type of business user needs this information? Why does it need this information
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
