SQL Server - Database

Card Puncher Data Processing

Management

Create

  • GUI

Sql Server New Database Studio

CREATE DATABASE TestDB
GO

List

SELECT Name from sys.Databases
GO
Name                                                                                                                           
----------
master                                                                                                                         
tempdb                                                                                                                         
model                                                                                                                          
msdb

Use

USE TestDB
GO

Drop

EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'yourdbname'
GO

USE [master]
GO
ALTER DATABASE [yourdbname] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

DROP DATABASE [yourdbname]
GO





Discover More
Card Puncher Data Processing
SQL Server - Getting Started

The Companion MOC: This are all script that you need to follow the course. Download de files: 10777A-ENU-Allfiles.exe The file contains...



Share this page:
Follow us:
Task Runner