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

http://sqlserver2012tutorial.com/

http://sqlserver2012tutorial.com/sql-server-management-studio-2012-what-is-it/

http://sqlserver2012tutorial.com/sql-server-2012-overview-of-sql-server-2012/

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 (3 of 5), we continue demonstrating how to create a table in SQL Server 2012. As with creating a database, in creating a table or fields here are some considerations:
- ‘Field Name’ should be intuitive and describe the information.
- ‘Field Data Type’ defines the type of data that can be stored (‘DATETIME’ for dates, ‘INT’ for numbers, etc.).
- ‘Field Size’ is important for performance and scalability.
- A ‘Primary Key’ (PK) in a table uniquely identifies a record.
- A ‘Foreign Key’ (FK) in the child or secondary table links to the PK in the parent table.
- ‘Constraints’ on fields can be used to validate data (ie. numbers only for SSN, phone number, etc.)

In this part, we demonstrate creating a Student table using SQL Server Management Studio (SSMS).

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