USE master
GO
CREATE DATABASE mydb
ON
( NAME = mydb_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\mydbdat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'mydb_log',
FILENAME = 'c:\program files\microsoft sql server\mssql\data\mydblog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GOuse mydb
go
create table ...
GO
CREATE DATABASE mydb
ON
( NAME = mydb_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\mydbdat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'mydb_log',
FILENAME = 'c:\program files\microsoft sql server\mssql\data\mydblog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GOuse mydb
go
create table ...
go
use mydb
go
create table student(id int,name varchar)