Get a demonstration of how to create a table using T-SQL commands in Microsoft SQL Server 2016.
- [Instructor] Now let's look…at using TSQL to create a table.…Here in SQL Server Management Studio,…I'll open up a New Query…and then I'll type in the keyword CREATE…and the keyword TABLE,…then I need to give the TABLE a name.…I'm going to call it Employee.…Then in parenthesis, I'll need to list all of the columns.…So I'll open the parenthesis.…I'll say my first column name will be EmployeeID,…and I want that column to be data type integer,…so I'll type in int.…Then before I type the name of the next column,…I need to put a ,…and my next column will be EmployeeName,…and for that, I want to use the data type varchar(50).…
So that concludes my column names.…I'll need to put a ) to signify the end of the columns.…And I'm going to add an option here.…If I just ran it right now,…it would create this on the default Filegroup,…but I want to work with a different Filegroup,…so I'll say ON Secondary,…and Secondary was a Filegroup I created previously.…I'll hit the red exclamation point for Execute.…It says Command(s) completed successfully.…
Author
Martin Guidry
Released
11/16/2016- Installing SQL Management Studio
- Using SQL Server Configuration Monitor
- Creating a database
- Creating tables with SMS and T-SQL
- Creating relationships between tables
- Creating views
- Writing queries to return XML
- Working with XML and JSON
- Backing up and restoring SQL Server
- Monitoring and management
- Security
- Performance
- Integrating SQL Server with cloud services like Azure
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m
-
-
1. Overview of SQL Server 2016
-
SQL Server editions2m 22s
-
2. Installing SQL Server 2016
-
Basic installation6m 22s
-
-
3. Working with Tools
-
Activity Monitor3m 31s
-
Profiler4m 20s
-
4. Creating and Configuring Databases
-
Create a database3m 16s
-
Install a sample database3m 12s
-
-
5. Creating Tables in a Database
-
Create a table using T-SQL1m 41s
-
In-memory tables3m 34s
-
Temporal tables5m 19s
-
6. Creating Views in Databases
-
Create a view3m 17s
-
-
7. Understanding Programmability
-
Stored procedures3m 23s
-
Built-in functions1m 50s
-
Scalar functions2m 10s
-
-
8. Working with XML
-
Introduction to XML1m 29s
-
Write queries to return XML2m 38s
-
Shred XML2m 23s
-
Working with XML schemas1m 48s
-
Storing XML3m 38s
-
-
9. Working with JSON
-
Working with JSON2m 29s
-
Storing JSON2m 19s
-
-
10. Backup and Restore
-
Basic backups2m 32s
-
Basic restore2m 48s
-
11. Monitoring and Management
-
Audit logins2m 35s
-
12. Security
-
Instance-level logins2m 47s
-
Database-level users2m 24s
-
Encrypt data5m 24s
-
13. Performance
-
Basics of indexes3m 4s
-
Create an index6m 18s
-
Columnstore index3m 12s
-
Explore execution plans5m 1s
-
Overview of Query Store3m 18s
-
-
14. Cloud
-
Back up to Azure3m 9s
-
Set up Stretch Database4m 46s
-
Monitor Stretch Database1m 24s
-
-
Conclusion
-
Next steps33s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create a table using T-SQL