Creating Tables in SQL | Online Course | Vertabelo Academy | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

20/27 NULLable columns – default behavior

1. Primary keys – Introduction

2. Primary keys – Syntax

3. Primary keys – Missing values

4. Primary keys – adding new values

5. Primary keys – duplicated values

6. Primary keys – NULL values

7. Primary keys – summary

8. Syntax revisited

9. Primary key data type

10. Primary keys in ERD

11. There can only be one...

12. ...but one there should be!

13. Multi-column primary keys – introduction

14. Uniqueness with multi-column primary keys

15. Uniqueness with multi-column primary keys – continued

16. Uniqueness with multi-column primary keys – summary

17. Multi-column primary keys in ERD

18. NOT NULL – Adding NULL values

19. NOT NULL – Creating tables

20. NULLable columns – default behavior

21. NULLable columns – default behavior continued

22. NULL columns

23. NULL or NOT NULL?

24. NULL in ERD diagrams

Good! The table has been created. Now, you may be curious about what happens when we do not provide the NOT NULL constraint. Let's find out.

Run the template code without the NOT NULL constraints. In the next exercise, we'll try to add a few rows.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.