下载SqlServer
下载SqlServer管理器: SQL Server Managemen Studio
T_sql语句
作用对sql sever数据库进行DDL DCL DML操作
在d盘database文件(需提前创建且不是源数据库位置)中创建数据库
create database MyFristDb
on
(
NAME=MyFirstDb,
FileName= 'D:\database\MyFirstDb.mdf',
Size=5mb,
MaxSize=unlimited,
FileGrowth=5%
)
LOG
ON
(
NAME=MyFirstDb_log,
FileName= 'D:\database\MyFirstDb.ldf',
Size=5mb,
MaxSize=60mb,
FileGrowth=5%
)