DEFINITIONS

Definitions More Info.
Definition ID12.068
TitleSQL
CategoryNOTES
Definitionlist synonym_name
Definition Descriptionhttps://anyonconsulting.com/business_intelligence/how-to-get-a-list-of-all-the-synonyms-in-sql-server-instance/

SELECT name AS synonym_name,
base_object_name AS synonym_definition,
COALESCE (PARSENAME (base_object_name, 4), @@servername) AS server_name,
COALESCE (PARSENAME (base_object_name, 3), DB_NAME (DB_ID ())) AS DB_name,
COALESCE (PARSENAME (base_object_name, 2), SCHEMA_NAME (SCHEMA_ID ())) AS schema_name,
PARSENAME (base_object_name, 1) AS table_name,
create_date,
modify_date
FROM sys.synonyms
ORDER BY synonym_name
RecordBycunay
Record Date14-03-2022 13:13:09
Düzenle
Kopyala
Sil