![]() We could modify this CREATE TABLE statement and define the employee_id as the primary key as follows: CREATE TABLE employeesīy specifying the words, PRIMARY KEY, after the employee_id field, SQL Server will create employee_id as the primary key for the employees table. Now the only problem with this CREATE TABLE statement is that you have not defined a primary key for the table in SQL Server. The fourth column is called salary which is a MONEY datatype which can contain NULL values.The third column is called first_name which is a VARCHAR datatype but can contain NULL values.The second column is called last_name which is a VARCHAR datatype (50 maximum characters in length) and also can not contain NULL values. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |