How to Create a Table in MS-SQL

Tables in MS-SQL Server, and other databases are created with the create table statement, where columns of the table are defined by specifying their names and data types.

create table employee (
	emp_id		integer,
	first_name	varchar(30),
	last_name	varchar(50),
	start_day	date,
	salary		decimal(8,2)
);
create table airport ( 	
	city		text, 
	airport_code 	char(3), 
	x_coordinate 	numeric,
	y_coordinate 	numeric,
	z_coordinate 	numeric
);

IN THIS PAGE