MS SQL Server 2012 How-to - Creating Database Objects in MS SQL Server 2012 - Part 3/5
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 (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
Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/