Creating a Database using Transact SQL statement

Posted by Muhsinathk under Sql Server on 6/13/2012 | Points: 10 | Views : 2575 | Status : [Member] | Replies : 4

Hi,

I want SQL query for creating a Database using Transact SQL statement..

Reply | Reply with Attachment

Posted by: Shoyebaziz123 on: 6/13/2012 [Member] Starter | Points: 25

0	create database ABC Muhsinathk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Ravianand on: 6/14/2012 [Member] Starter | Points: 25

0	Hi, Create Database Abc(database_name) Regards, Ravi Muhsinathk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/14/2012 [Member] Bronze | Points: 25

0	I got the answer.. Use this query CREATE DATABASE db_name [ON[PRIMARY]{file_spec1},...] [LOG ON {file_spec2},...] [COLLATE collation_name] [FOR{ATTACH\| ATTACH_REBUILD_LOG}] Muhsinathk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sriramnandha on: 6/21/2012 [Member] Starter | Points: 25

0	CREATE DATABASE <DATABASE_NAME> EXAMPLE: CREATE DATABASE TEST REGARDS SRIRAM.R sriram Muhsinathk, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts