Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why is "TRANSFER" colored blue in SSMS?

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.

like image 209
saima Avatar asked Dec 03 '13 04:12

saima


1 Answers

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

like image 126
Kirill Polishchuk Avatar answered Sep 25 '22 16:09

Kirill Polishchuk