keywords in sql server

Question

Post reply

keywords in sql server

sql Anand

SSCommitted

Points: 1597
More actions
January 19, 2012 at 12:11 am

#253841

hi
i want to see keywords in sql server 2008
in oracle by using this query-
help reserved words;
we will get all the keywords in oracle..so is there any way to see keyword in sql server by using query

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

No.

But in SQL Server 2008 there is the intellisense option that will produce a list of the keywords as you type.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 2

sql Anand (1/19/2012)
i want to see keywords in sql server 2008

...or checking the documentation http://msdn.microsoft.com/en-us/library/ms189822.aspx

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 3

One thing to keep in mind. If you are typing a query in SSMS, the keywords will change color on you (depending on your SSMS options) so that you can tell they are keywords just by looking at them.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

bsdtux Mr or Mrs. 500 Points: 522 More actions · Answer 4

While I can't think of any way of getting keywords through a query, the best way I have found to locate keywords is to use SQL Server Books Online.

Just a quick look through books online it gives future keywords, SQL keywords, ODBC keywords, and other information.

I know this is not the answer you where looking for but I believe this is a great alternative and usually installed with most installations of SQL Server.