Why is "TRANSFER" colored blue in SSMS?
sql, sql-server, ssms, t-sql
Solution
Yes, it is. Is used by `ALTER SCHEMA` command.
ALTER SCHEMA schema_name
TRANSFER [ <entity_type> :: ] securable_name [;]
<entity_type> ::=
{
Object | Type | XML Schema Collection
}
Reference: http://msdn.microsoft.com/en-us/library/ms173423%28v=sql.105%29.aspx
Problem
Is `TRANSFER` a keyword or reserved word in MS SQL SERVER ,because when I type this word in SQL server management studio its colour turns blue? When I checked this word in Microsoft's list of Reserved Words it was not mentioned there. Can someone please help me to know when and why colour of words changes in management studio of SQL server.