MS SQL Server 2012 How-to - Creating Database Objects in MS SQL Server 2012 - Part 2/5

Опубликовано: 01 Февраль 2017
на канале: baghul

157

https://sqlserver2014tutorial.com/

In this MS SQL Server 2012 training video series, we cover database objects and how to create them. A database object is any defined object in a database that is used to store or reference data. Some examples of database objects include tables, views, clusters, sequences, indexes, and synonyms.

You can create a database or object through Microsoft SQL Server Management Studio (SSMS), Transact SQL (TSQL) or the Template Browser.

In this part (2 of 5), we look at and demonstrate creating a database using Transact SQL (TSQL) using the ‘CREATE DATABASE’ command. Syntax for this method:
CREATE DATABASE [name of database] ON
LOG ON
o NAME – Logical name for data file
o FILENAME – Physical location for data file
o SIZE – Initial size in megabytes (MB)
o MAXSIZE – Maximum file size in MB
o FILEGROWTH – Filegrowth parameter using percent or MB
ALTER DATABASE – Modifies a database, files or filegroup associated with a database
sp_helpdb – Gives basic information on database
DROP DATABASE – Deletes a database

In the second part of this video, we look at creating a table in SQL Server 2012. Just like the Database Object, the Table Object can be created using SSMS, TSQL or Template Browser.

A Table is made up of Fields / Columns (Info like SSN, CustomerID) and Records / Rows (complete instance of one item or specific customer).

Please subscribe to our channel and like our videos! We have many training videos on MS SQL 2012

Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/

На этой странице сайта вы можете посмотреть видео онлайн MS SQL Server 2012 How-to - Creating Database Objects in MS SQL Server 2012 - Part 2/5 длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь baghul 01 Февраль 2017, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 157 раз и оно понравилось 1 зрителям. Приятного просмотра!

1,614