<p>在创建一个新的对象时,除了创建者、系统管理员、数据库所有者(如果创建的对象是数据库,那么数据库所有者就是创建者)以外,其他人都无法访问。这允许您在创建对象后,进行所需要的任何修改,之后才明确允许其他人访问您创建的对象。</p>
还需要注意的是:只能使用CREATE语句在本地服务器上创建对象(添加特定的服务器名称是不起作用的)。
完整的语法列表:
CREATE DATABASE <database name> [ON [PRIMARY] ([NAME = <'logical file name'>, ] FILENAME = <'file name'> [, SIZE = <size in kilobytes, megabytes, gigabytes, or terabytes>] [, MAXSIZE = size in kilobytes, megabytes, gigabytes, or terabytes>] [, FILEGROWTH = <kilobytes, megabytes, gigabytes, or terabytes|percentage>])] [LOG ON ([NAME = <'logical file name'>,] FILENAME = <'file name'> [, SIZE = <size in kilobytes, megabytes, gigabytes, or terabytes>] [, MAXSIZE = size in kilobytes, megabytes, gigabytes, or terabytes>] [, FILEGROWTH = <kilobytes, megabytes, gigabytes, or terabytes|percentage>])] [ COLLATE <collation name> ] [ FOR ATTACH [WITH <service broker>]| FOR ATTACH_REBUILD_LOG| WITH DB_CHAINING ON|OFF | TRUSTWORTHY ON|OFF] [AS SNAPSHOT OF <source database name>] [;]
以下是一个示例:
CREATE DATABASE Accounting ON (NAME = 'Accounting', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AccountingData.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5) LOG ON (NAME = 'AccountingLog', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AccountingLog.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB); GO