• Home
• us.fatehi
• schemacrawler-sqlserver
• 16.22.3
• source code
• EXT_SYNONYMS.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sqlserver.information_schema.EXT_SYNONYMS.sql Maven / Gradle / Ivy

SELECT
  DB_NAME() AS SYNONYM_CATALOG,
  SCHEMA_NAME(SCHEMA_ID) AS SYNONYM_SCHEMA, 
  NAME AS SYNONYM_NAME, 
  PARSENAME(BASE_OBJECT_NAME, 4) AS REFERENCED_OBJECT_SERVER,
  PARSENAME(BASE_OBJECT_NAME, 3) AS REFERENCED_OBJECT_CATALOG,
  PARSENAME(BASE_OBJECT_NAME, 2) AS REFERENCED_OBJECT_SCHEMA,
  PARSENAME(BASE_OBJECT_NAME, 1) AS REFERENCED_OBJECT_NAME
FROM 
  SYS.SYNONYMS