sql server 2数据库实现（SQL Server 2数据库实现）.docVIP

sql server 2数据库实现（SQL Server 2数据库实现） SQL SERVER 2 database implementation 1, create database syntax Create database database name On[primary] ( data file parameter ,... N] [ file group parameters ] ) [LOG ON] ( log file parameter ,... N] ) Be careful： Where []] represents the optional part, and {} indicates the need Create database instance: Create database NetBarDB On primary - defaults to the primary master file group, which can be omitted ( Name=NetBar_data-- the logical name of the master data file Filename=e:\NetBar_mdf.mdf- - the physical name of the master data file Size=3mb -- the initial size of the master data file Maxsize=100mb -- the maximum growth of the master data file Filegrowth=15% -- the growth rate of master data files ) Syntax for creating database data files and log files: CREATE DATABASE database name On { NAME= logical name, FILENAME= physical file name, SIZE= file size, The maximum size of the MAXSIZE= file can be long, FILEGROWTH= automatic growth } Log on { ........................... } 2, delete database syntax: Drop database database name; Delete multiple databases: The drop database database name 1, the database name 2, and the database name n; Be careful： Deleting the database using the drop statement will delete Associated with the database to be deleted in the disk Files such as data files and log files Delete database example: If exists (select * from, sysdatabases, where, name=NetBarDB) Drop database NetBarDB Go Or: If, DB_ID (NetBarDB), is, not, null Drop database NetBarDB Go 3, create table syntax: Create table table name ( Field 1 data type field features, Field 2 data type field features, ...... Field n data type field features, ) 4, modify table syntax: Add column: Alter table table name Add {fields, data types, field characteristics} [..., n] Delete column: Alter table table name Drop column {field} [...... n] Modify column: Alter table table name Alter column field data type [null|not null] 5, delete the syntax of the table