Attach a mdf file to database : Create Database « Database « SQL Server / T-SQL Tutorial






CREATE DATABASE Database_1b
ON PRIMARY (FILENAME = 'c:\Database_1a.mdf')
FOR ATTACH
GO
SELECT name, database_id FROM sys.databases
EXEC sp_helpdb @dbname = N'Database_1b'
GO








19.1.Create Database
19.1.1.Creation of a Database
19.1.2.A CREATE DATABASE Example
19.1.3.create and drop database
19.1.4.If a database exists
19.1.5.A statement that attaches an existing database file
19.1.6.Create a database by specifying the mdf file
19.1.7.Create a database by indicating the mdf file
19.1.8.Attach a mdf file to database
19.1.9.Creates a database with explicit specifications for database and transaction log files.