Creating Tables in SQL | Interactive Course | Vertabelo Academy

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

22/30 IDENTITY parameters - continued

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. Multicolumn primary keys - introduction

14. Uniqueness with multicolumn primary keys

15. Uniqueness with multicolumn primary keys - continued

16. Uniqueness with multicolumn primary keys - summary

17. Multicolumn primary keys in ERD

18. New keyword IDENTITY

19. Auto-increment with IDENTITY

20. Creating columns with IDENTITY

21. IDENTITY parameters

22. IDENTITY parameters - continued

23. The AUTO_INCREMENT keyword

25. Retrieving data from sequences

26. Auto-numbering in various databases

27. Revision #1

28. Revision #2

29. Revision #3

Good! Now, we should only have odd numbers as ids in our table cinema. Let's check that.

Add a few rows to our table cinema and see how the column cinema_id is generated.

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.