Easily set up automatic Primary key on existing database

Опубликовано: 13 Ноябрь 2024
на канале: Data friendly
351
4

In some cases, there is no need to have a primary key on the tables. But what if suddenly you need your tables to have it? Here is an easy way to have it with a new column that would make unique primary key values automatically.

--------------------------------------------
TABLE OF CONTENTS
--------------------------------------------

00:00 - Introduction
02:25 - Script to create new tables
03:56 - Identity and we need it
06:43 - Conclusion

Like my video? Patreon link to support me, get extra perks, and download files I have created in my videos:   / datafriendly