Default image

Eric

Code guy.

Search for a column name in any table

Most directly, you can run this in SQL Server to confirm that a column exists — but that alone is only somewhat useful. Really what you want to know is both that the column exists and the table it lives…

Drop a table if it exists before trying to create it

This comes in handy if you need to create an idempotent scripts. For example, a script to create your database’s tables (or other entities) might check for their existence before attempting to create them. Note that the above DROP TABLE…

Welcome to SQL Strong

Welcome to SQLStrong, a site dedicated to the study of databases and database technology, emerging technologies like GraphQL, and, of course, SQL. Here’s a story about why I decided to start this blog. My name is Eric. I’ve worked in…