Jump to content

create database and table


joecool2005

Recommended Posts

Hi On the following SQL file

CREATE DATABASE employeeDBuse employeeDBCREATE TABLE Persons(P_Id int NOT NULL,LastName varchar(255) NOT NULL,FirstName varchar(255),Address varchar(255),City varchar(255),PRIMARY KEY (P_Id))

I got an error because the database employeeDB is not created.How do you in the same script create a database then a table?ThxJoe

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...