Creating and viewing data for T-SQL Introduction

Source: Internet
Author: User
Tags filegroup mssqlserver
Create a database IFDB_ID (MyDatabase6) ISNOTNULLDROPDATABASEMyDatabase6; CREATEDATABASEMyDatabase6ONPRIMARY (-- primary data file NAMELogicNameOfDataFile6_1, FILENAMEC: bytes

Create database if DB_ID ('mydatabase6 ') is not null drop database MyDatabase6; create database MyDatabase6 on primary (-- PRIMARY profile NAME = 'logicnameofdatafile6_1', FILENAME = 'C: /Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/

Create a database

IF DB_ID ('mydatabase6 ') IS NOT NULL

Drop database MyDatabase6;

Create database MyDatabase6

ON PRIMARY

(-- Primary data file

NAME = 'logicnameofdatafile6_1 ',

FILENAME

= 'C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/DATA/DataFile6_1.mdf ',

SIZE = 5 MB, -- set the initial SIZE

MAXSIZE = 100 MB, -- set the maximum storage space for a data file

FILEGROWTH = 15% -- set the automatic growth rate

),

FILEGROUP UserFG6_2 -- allocate the database file DataFile6_2.ndf to the file group UserFG6_2.

(-- Secondary data file

NAME = 'logicnameofdatafile6_2 ',

FILENAME

= 'C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/DATA/DataFile6_2.ndf ',

SIZE = 2 MB, -- set the initial SIZE

MAXSIZE = 100 MB, -- set the maximum storage space for a data file

FILEGROWTH = 10% -- set the automatic growth rate

),

FILEGROUP UserFG6_3 -- allocate the database file DataFile6_3.ndf to the file group UserFG6_3.

(-- Secondary data file

NAME = 'logicnameofdatafile6_3 ',

FILENAME

= 'C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/DATA/DataFile6_3.ndf ',

SIZE = 3 MB, -- set the initial SIZE

MAXSIZE = 100 MB, -- set the maximum storage space for a data file

FILEGROWTH = 5% -- set the automatic growth rate

)

Log on (

-- Set the logical name of the log file

NAME = 'logicnameoflogfile6 ',

-- Set the log file

FILENAME

= 'C:/Program Files/Microsoft SQL Server/MSSQL10.MSSQLSERVER/MSSQL/DATA/LogFile6.ldf. ldf ',

SIZE = 10 MB, -- set the initial SIZE

MAXSIZE = 100 MB, -- set the maximum storage space for a data file

FILEGROWTH = 1 MB -- set the automatic growth rate

)

View Database

There are multiple ways to view a database. You can view system tables or use system stored procedures.

SELECT type_desc,

Name,

Physical_name,

Size,

Max_size,

Growth

FROM sys. database_files -- view system a. sys. database_files

GO

Sp_helpdb

The storage process sp_helpdb provides the ability to view basic database information. It is actually an encapsulation of several t-SQL commands.

These commands extract data from related system tables to obtain basic database information.

Syntax:

Sp_helpdb Database Name

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.