Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating database and tables

Status
Not open for further replies.

davv

Programmer
Apr 18, 2001
10
SE
Is it possible, in the same sql-script, to create a database and it´s tables? It should be ofcourse but I cant find the right syntax anywhere. It should be something like...

GO
create database KD211SYS3U1;
GO

--SKAPA TABELLER--
create table KD211SYS3U1.dbo.tblLakare(
fltDoktorID int IDENTITY(1,1) primary key not null,
fltFnamn char(20),
fltEnamn char(20)
)

newbie

dav
 
I'm sorry..... now it works for some reason?

;)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top