KEYWORDS SCRIPT ================ Simon Walker put together this nice script to populate a table of Sybase keywords. This is very nice when you want to port form one version to another!!!! You can do searches on syscomments, syscolumns, sysobjects... and find keywords of interest in a given database. We dont have a proc for this but if you write one, send it in! Ed ----------------------------------- keywords.sql script to create and populate a keywords table for Sybase 10, MS 6 and ANSI. The information here was extracted from online documentation current for Sybase 10 and 11 and MS SQL 6 on Jan 30 1996. It includes the current keywords for those products (the Sybase 11 set comprises only the additions to the Sybase 10 set), and also words that are ANSI-SQL 92 reserved words, potential future ANSI reserved words, and potential future MS SQL reserved words. ** This script does not install to any particular database!! ** keywords a list of uppercased keywords, with an origin_id that joins to: keywords_origin a list of sources for the keywords exec check_keyword to show the list, in alpha order with origin exec check_keyword 'word' to see if 'word' is in the list Data is supplied as INSERT statements for simplicity. Please hack this SQL to your requirements, but if you pass it on, please leave it intact. Thanks. Who When Why ----------------------------------------------------------------- simon 30jan96 created at The SQL Workshop, Milton Keynes, UK walker siwalker@cix.compulink.co.uk ********************************************************************/