,
asics gel
( [ NAME = logical_file_name , ]
Create Database in Sql Server 2005, Database Statements
Following is the full syntax used for creating database in Sql Server 2005.
CREATE DATABASE database_name
To rename a user-defined database use :
To drop a user defined database use following command:
Regards,
asics sale,
NOTE : Everything written between [ ] is optional .
SQL SERVER 2005 contains the following system database :
[ ON [ PRIMARY ]? [ <? filespec >] ]
sp_renamedb old_database_name ,
new hogan, new_database_name
PRIMARY specifies the associated <filespec> list that defines files in the primary filegroup.
[ ,
Onitsuka Tiger Mexico Mid, FILEGROWTH = growth_increment ] ) [ ,.... n ]
sp_helpdb [ database_name ]
NAME=logical_file_name specifies the logical name for the file.
FILENAME=os_file_name specifies the operating-system file name for the file.
Anuj Tripathi
[ , MAXSIZE = max_size ]
DROP DATABASE database_name
master
tempdb
model
msdb
Resource
Note: you cannot delete a system-defined database.
MAXSIZE=max_size specifies the maxium size to which the file defined in the <filespec> list can grow.
< filespec > : : =
Remember - " FILEGROWTH setting for a file cannot exceed the MAXSIZE setting"
But remeber that to create a database you must be a member of the dbcreator server role.
After a database is created, to check details of the database use following command :
-------------------------------------------------------------------------------------------------------------------------------------------
Fortunately you can also create a database by a right click on the object explorer,
tods 2011, Thanks to SQL SERVER Management studio 2005.
[ , SIZE = size ]
FILEGROWTH=growth_increment specifies the growth increment of the file defined in the <filespec> list.
LOG ON specifies the disk files used to store log files.
FILENAME = 'os_file_name'
If u have any query feel free to ask. If u like this post , rate & comment it.
--------------------------------------------------------------------------------------------------------------------------------------------
{ LOG ON [ < filespec > ] ]
Description ::-
ON specifies the disk file used to store the data portion of the database.
Easily Fix Internet Explorer Errors On A Safe Way- How To Guide_11245
Game Copier Software - A Tool That Will Help You Back Up Your Games_10234
enter the market during this period, many global companie enter the field for manufacturing
share. The American population fell in love with the Nike Dunks SB. Many competing products
over the years. In the 20th century, early 80s, most of the basketball fans captured the market.