Background Wanted to see how hard it will be to play around with the sakila MySQL Database. Objective Our objective will be to add a couple of records to the sakila.customer table. Because the table has a couple of foreign keys, we need to get a handle to valid entries in those tables, as well. … Continue reading MySQL – Sample – Sakila – Adding new customer record
Database ( Technical )
SQL Beautifier
Background As a Database Administrator get so see a bit of SQL Statements. Avenues The SQL gets to the DBA through various avenues, inclusive :- Developers Submitted to review and execute against Production Database Monitoring Tools In quite a few cases, the first thing one has to do is space things out a bit. SQL … Continue reading SQL Beautifier
“Entity Relationship” meets poetry
Background Researching an issue and wanted to see the best choice for a name. Googled on it and found good reasoning. Question The Question is :- Image Text Table: Color Columns: Id, ColorName, ColorCode Table: Shape Columns: Id, ShapeName, VertexList What should I call the table that maps color to shape? Table: ??? Columns: ColorId, … Continue reading “Entity Relationship” meets poetry
DBeaver
Background Here I am having used SQL Server Management Studio ( SSMS ) for so long, I am satisfied. It's GUI is versely superior to SQL 2000 Query Analyzer and it exposes just about every SQL Functionality that I use on daily basis. Stumped Spent hours trying to capture a query's grid display unto … Continue reading DBeaver
Transact SQL – Constraint – Primary Key
There are a couple of approaches one can use to get the primary key for a table. Here are some of those ways: sp_pkeys sp_primarykeys INFORMATION_SCHEMA.TABLE_CONSTRAINTS sp_pkeys Syntax: Sample: Output: sp_primarykeys Though sp_primarykeys was added to gain insight into remote data sources, you can use it it to query your local data source, as well. … Continue reading Transact SQL – Constraint – Primary Key
