From dbscript Online Help
wikibot
Table
|
HumanResources.Employee
|
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
EmployeeID
|
int
|
not null
|
|
PK_Employee_EmployeeID
|
|
NationalIDNumber
|
nvarchar(15)
|
not null
|
|
|
AK_Employee_NationalIDNumber
|
ContactID
|
int
|
not null
|
|
|
|
LoginID
|
nvarchar(256)
|
not null
|
|
|
AK_Employee_LoginID
|
ManagerID
|
int
|
null
|
|
|
IX_Employee_ManagerID
|
Title
|
nvarchar(50)
|
not null
|
|
|
|
BirthDate
|
datetime
|
not null
|
|
|
|
MaritalStatus
|
nchar(0)
|
not null
|
|
|
|
Gender
|
nchar(0)
|
not null
|
|
|
|
HireDate
|
datetime
|
not null
|
|
|
|
SalariedFlag
|
dbo.Flag
|
not null
|
((1))
|
|
|
VacationHours
|
smallint
|
not null
|
((0))
|
|
|
SickLeaveHours
|
smallint
|
not null
|
((0))
|
|
|
CurrentFlag
|
dbo.Flag
|
not null
|
((1))
|
|
|
rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_Employee_rowguid
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
Triggers
|
Type
|
dEmployee
|
INSTEAD OF DELETE
|