Find a column named XXXX in tables or views

Find a column named XXXX in tables or views:


SELECT      COLUMN_NAME AS 'ColumnName', TABLE_NAME AS  'TableName'
FROM        INFORMATION_SCHEMA.COLUMNS
WHERE       COLUMN_NAME LIKE '%XXXX%'
ORDER BY    TableName, ColumnName; 

Comments

Post a Comment

Popular posts from this blog

GHL Email Campaigns

GHL Email Campaigns Options  Option 1)    Tag free - Contacts > Quick Search box > filter data clicking to select > "Add to Automation" button > pick automation.  Option 2)   Automations > Workflows tab > pick workflow > start workflow with trigger component > click on it > pick "Contact Tag" >  "Add Filters" button > on filter add one that is "Tag Added" > pick which  type of tag. What Are The Tags 1) Settings > Tags > list of tags How to Add Tags 1) Bulk - Contacts > Quick Search box > filter data clicking to select > "Add Tag" button > pick tag 2) Single - Add tag when add contact 3) Bulk - ( Only Admin ) - In file to import, put Tags in column - Contacts > Import Contacts button > Contacts > decide columns. Everyone seems to tag the import with date AND tag it cold or hot if they can. 4) 
Read more

JSON Web Tokens

Image
 JSON Web Tokens (JWT)   A JSON Web Token (JWT) is commonly used for authentication and authorization in web applications and APIs. Essentially, JWTs encode info about a user or entity into a JSON object, which is then digitally signed and/or encrypted.  A JWT consists of three parts, separated by dots (.):  1. Header: Contains metadata about the token, such as the signing algorithm (e.g., HMAC SHA256, RSA SHA256) and the token type (JWT).  2. Payload: Contains the claims, which are statements about an entity (e.g., user ID, role, expiration time).   3. Signature: Verify that the JWT sender is who they claim to be and that the message hasn't been tampered with.  How it works:   Authentication: A user logs in, and the server creates a JWT containing user info and other relevant claims.    Token Transmission: The server sends the JWT to the client (e.g., browser).    Subsequent Requests: The client includes the JWT in the au...
Read more

Death of Codeium & Windsurf

  Windsurf May 15, 2025     I have been doing a bunch of research on AI this week.  I tried the Codeium company's (https://codeium.com/) Windsurf Editor and Cascade AI combination.  The Windsurf Editor is just a branch of Visual Studio Code editor, but with a few addons, but the main thing is the integration to the included Cascade AI.       The Cascade AI gets a traditional prompt of what code you want to code generate and attempts to automate the code generation using AI by instead of only displaying code suggestions. Overall Cascade AI is really cool, but I found in my attempt that it got into an infinite loop when attempting to compile a C# program.   UPDATE - 7/17/2025 - Discovered that Codeium and WindSurf was bought by Cognition on July 14, 2025.  "Last week we lost our founders and our research team" at WindSurf.  New tool will be merged with Devin at Cognition: https://cognition.ai/ . Codeium company/ Windsurf Edi...
Read more