Which table are Aliases stored in?

user_444335 0
Viewed 1250

In Sitecore I have created an alias called "bob" for a page.

screenshot

For most items in Sitecore, the data is saved in the Items table in the database. You can easily see these if you search using the Item ID.

However whenever I search for an alias it returns no results:

select * from Items where ID ='0134A009-5D38-43C1-96C6-33C305543B7B'

Are aliases stored in a different location?

I have tried manually looking through all the tables and also ran a script which should search the whole database. If it is stored there then it looks like it is not in plain text.

sitecore sql-server
1 Answers

Aliases like any other items are stored in the Items table.

You should check if you're looking for the Alias in the proper database. Maybe You're checking core or web database instead of master?

I've created a Bob alias in my env and query below returns 1 row containing alias details:

SELECT
 *
FROM 
 [dbo].[Items] 
WHERE 
 ID = '03275C36-32CE-47F7-AD28-9D5D2649E934'
user_1578330
Related