How to Create a Table in Oracle/Sql Server 2005 / TeraData

Create Table in Oracle

create table Department
(department_number Smallint,
department_name char(30) not null,
budget_amount decimal(10,2),
manager_employee_number integer);

Create Table in TeraData

create table Employee, Fallback
(employee_number integer,
manager_employee_number integer,
department_number integer,
job_code integer,
last_name char(20) not null,
first_name varchar(30) not null,
hire_date Date not null,
birthdate Date not null,
salary_amount Decimal(10,2) not null)
Unique Primary Index (employee_number);

SQL Server 2005

create table Department
(department_number Smallint,
department_name char(30) not null,
budget_amount decimal(10,2),
manager_employee_number integer);