SQL Server 关键字'ON'附近有语法错误

create database COMPANY1
ON
(
name='COMPANY_DATA',
FILENAME='D:\MSSQL\DATA\COMPANY.MDF',
SIZE=20MB,
MAXSIZE=50MB,
FILEGROWTH=25%
)
LOG ON
(
name='COMPANY_LOG',
FILENAME='D:\MSSQL\DATA\COMPANY.LDF',
SIZE=3MB,
MAXSIZE=10MB,
FILEGROWTH=1MB
)

 

求问一下哪里有语法错误,谢谢大家

如下:

参考:https://docs.microsoft.com/zh-cn/sql/relational-databases/databases/create-a-database?view=sql-server-2017

USE master ;  
GO  
CREATE DATABASE COMPANY1  
ON   
( NAME = COMPANY_DATA,  
    FILENAME = 'D:\MSSQL\DATA\COMPANY.MDF',  
    SIZE = 20,  
    MAXSIZE = 50,  
    FILEGROWTH = 25 )  
LOG ON  
( NAME = COMPANY_LOG,  
    FILENAME = 'D:\MSSQL\DATA\COMPANY.LDF',  
    SIZE = 3MB,  
    MAXSIZE = 10MB,  
    FILEGROWTH = 1MB ) ;  
GO

您好,我是有问必答小助手,你的问题已经有小伙伴为您解答了问题,您看下是否解决了您的问题,可以追评进行沟通哦~

如果有您比较满意的答案 / 帮您提供解决思路的答案,可以点击【采纳】按钮,给回答的小伙伴一些鼓励哦~~

ps:问答VIP仅需29元,即可享受5次/月 有问必答服务,了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632