Question: Write an SQL script to build a table. Call the script spCreateTable() it should accept one argument, a varchar called subjectOfTable. subjectOfTable is a varchar
Write an SQL script to build a table.
Call the script spCreateTable() it should accept one argument, a varchar called subjectOfTable.
subjectOfTable is a varchar containing the subject of the table. Some examples are example Employee or Formula. Your script will use that subject to build the table name, primary key, and natural key.
For example, given Employee as the subject, your script will build a table called tEmployee with a surrogate key called EmployeeID and a natural key called Employee. Be sure to create the necessary constraints for the keys.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
