sybase create database

USE master
go
CREATE DATABASE bsjdw
    ON bsjdw=20000
    LOG ON bsjdwlog=5000
go
USE master
go
--EXEC sp_dboption 'bsjdw','abort tran on log full',true
--go
--EXEC sp_dboption 'bsjdw','allow nulls by default',true
--go
--EXEC sp_dboption 'bsjdw','auto identity',true
--go
--EXEC sp_dboption 'bsjdw','dbo use only',true
--go
--EXEC sp_dboption 'bsjdw','ddl in tran',true
--go
--EXEC sp_dboption 'bsjdw','identity in nonunique index',true
--go
--EXEC sp_dboption 'bsjdw','no chkpt on recovery',true
--go
--EXEC sp_dboption 'bsjdw','no free space acctg',true
--go
--EXEC sp_dboption 'bsjdw','read only',true
--go
EXEC sp_dboption 'bsjdw','select into/bulkcopy/pllsort',true
go
--EXEC sp_dboption 'bsjdw','single user',true
--go
EXEC sp_dboption 'bsjdw','trunc log on chkpt',true
go
USE bsjdw
go
CHECKPOINT
go
USE bsjdw
go
EXEC sp_changedbowner 'sa'
go
IF DB_ID('bsjdw') IS NOT NULL
    PRINT '<<< CREATED DATABASE bsjdw >>>'
ELSE
    PRINT '<<< FAILED CREATING DATABASE bsjdw >>>'
go

转载于:https://www.cnblogs.com/sanle/archive/2006/07/04/442666.html