Tag Archives: SQLNewBlogger

Changing the Data Type of a Primary Key–#SQLNewBlogger

Posted on November 20, 2023 by way0utwest

A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this. This is the happy path, and not intended to cover all … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Creating a Self Referencing FK in a CREATE Statement–#SQLNewBlogger

Posted on November 6, 2023 by way0utwest

I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this would also work for a self-referencing FK. It does, and I … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Adding a Foreign Key in the CREATE TABLE statement–#SQLNewBlogger

Posted on October 30, 2023 by way0utwest

I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post for me that is simple and hopefully serves as an example … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Deleting a Git Branch–#SQLNewBlogger

Posted on October 23, 2023 by way0utwest

I had someone ask me recently about deleting branches. While I had known how to delete a local branch, I had to look up how to delete a remote one. Documenting these both will hopefully help me remember this. Another … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Deleting a Git Branch–#SQLNewBlogger