Fetching metadata with SQL Server 2005

Fetching metadata is much more easier with SQL Server 2005 than it was with SQL Server 2000's esoteric system tables.

The system tables from previous versions of SQL Server are now implemented as a series of views called (appropriately enough) compatibility views. All of these views can be found in the sys schema.


Find all tables in a Database (Then-Now)

SQL SERVER 2000:
select name from sysobjects where type='U'

SQL SERVER 2005:
select name from sys.tables

Comments

Post a Comment

Popular posts from this blog

HOW TO Filter Products on Open Food Facts by Country (India) Using DuckDB & Superset

Image
Open Food Facts (OFF) is a crowd-sourced database of food products from around the world.  Somewhere in the world, a shopper scans the barcode on a packet of biscuits and adds basic product details. Another person photographs a package label for the same product in Hyderabad. A volunteer in France fixes a typo.  That's Open Food Facts, a volunteer-built, openly licensed database of food products that's continually changing and growing. Each product is identified by a barcode and carries ingredients, nutrition facts, brands, labels and more. The whole database has millions of products, and let's say you only want the products recorded as being sold or available in one country like India. There are multiple ways to extract a subset of the OFF database. I have already tried using the daily dump available on Hugging Face through Google Colab and GitHub Actions in the past but it blew my mind that using the OFF deployed Apache Superset , you can execute a SQL query in a brows...
Read more

Oracle University Free Courses & Certification Exam Prep Material (2026)

Image
A few decades ago, quality training was scarce and costly. Thanks to the convergence of several new advancements, software vendors now provide online training to a worldwide audience, making skill acquisition more accessible than ever. Microsoft offers its Microsoft Learn platform, Google provides Google Skills , and Oracle University is doing a great job of delivering training for their products while also covering higher-level concepts relevant to the database, cloud, and AI domains. The following Oracle certification exams are free to take and come with learning resources: Oracle Cloud Infrastructure Foundations Associate (1Z0-1085-26) Oracle Cloud Infrastructure Architect Associate (1Z0-1072-26)   Oracle Data Center Operations Foundations Associate (1Z0-3000) Oracle Multicloud Foundations Associate (1Z0-1144-26) Oracle Cloud Infrastructure AI Foundations Associate (1Z0-1122-26) Oracle AI Database Foundations Associate (1Z0-1195-26) Additionally, Oracle University offers many ...
Read more

HOW TO Spot AI Trickery in Images

Image
Sunday newspapers once featured fun “spot the difference” puzzles with two similar images. That same careful eye is now essential in the AI era to avoid falling for manipulated images. Here’s a practical checklist based on a New York Times article  to tell if a photo is an AI fake: Check the perspective - Look at lines that should run straight into the distance (like floor tiles or walls). Do they bend, warp, or point in different directions? Watch for prompt keywords - Scan for brand names, place names, or other words from the original prompt that appear in strange or overly prominent places. Zoom in on small text - Big letters may look fine, but smaller writing often turns into gibberish. Also look for odd soft shadows on the characters. Examine how objects connect - Does a strap actually attach to a badge? Do skin tones match between a person and the photo on their ID? AI often fails at real physical relationships. Read the text carefully - Even sharp, pixel-perfect text can be ...
Read more