How to find a column reference in a given database schema

-
Run the below query
SELECT T.NAME AS TABLE_NAME,SCHEMA_NAME(SCHEMA_ID) AS SCHEMA_NAME,C.NAME AS COLUMN_NAME
FROM SYS.TABLES AS T
INNER JOIN SYS.COLUMNS C ON T.OBJECT_ID = C.OBJECT_ID
WHERE C.NAME LIKE '%User%'
ORDER BY SCHEMA_NAME, TABLE_NAME;
Output:



Comments

Post a Comment

Popular posts from this blog

Run OpenAI Codex Inside Claude Code via MCP

-
Image
  How to Use OpenAI Codex Inside Claude Code with MCP Claude Code is already capable of inspecting repositories, editing files, running commands, and coordinating complex engineering work. But there are times when you may want Claude to delegate a focused task to OpenAI Codex—for example: Ask Codex to implement a change while Claude reviews it. Use Codex for a second independent code review. Let Codex clean up a technical review document. Run a repeatable Codex skill from a Claude Code session. Use Claude as the orchestrator and Codex as a specialist execution agent. The cleanest way to build this workflow is through the Model Context Protocol , or MCP. However, the phrase “install Codex inside Claude” can create the wrong mental model. Codex is not inserted into the Claude model. Instead, Claude Code launches Codex as a separate local process and communicates with it through an MCP tool interface. Claude orchestrates. Codex executes. Claude verifies. Alt text: Claude Code connecte...
Read more

I Built an AI Reviewer That Refuses to Tell Me If My Idea Will Work

-
Image
This blog has been quiet for ten years — the last post here is a Windows 10 dark-theme registry hack. I'm putting it back to work. Going forward this is where I'll write about the AI systems and tools I'm building, with more room than a social post gives me. First one: a small protocol that talked me out of a bad idea before I wasted months on it. The wrong question The first startup idea I tested with my own AI review protocol didn't survive the review. That wasn't a failure of the protocol. It was the point. I built the protocol after realizing something uncomfortable: asking an LLM whether an idea is good is almost the wrong question. Modern language models are very good at constructing coherent arguments, but they can't determine whether a business will succeed — that depends on evidence the model simply doesn't have. Ask for a brutal review and you usually get the tone of criticism wrapped around the same underlying agreement. Better prompting ...
Read more