An IT Solution

Generally the major issue we face while development is the availability of common functions in different database(s). I am facing this issue from last so many years. Then I had start preparing a table for common functions of different database(s). The commonly used databases are Oracle, Sql Server and My Sql. Their is so many other database(s) are also available but commonly I works on these database(s) only. Following is the common list of functions in different database(s):- Math Functions Function - Absolute value Oracle - ABS SQL Server - ABS My Sql - ABS Function - Arc cosine Oracle - ACOS SQL Server - ACOS My Sql - ACOS Function - Arc sine Oracle - ASIN SQL Server - ASIN My Sql - ASIN Function - Arc tangent of n Oracle - ATAN SQL Server - ATAN My Sql - ATAN Function - Arc tangent of n and m Oracle - ATAN2 SQL Server - ATAN2 My Sql - Please Suggest Function - Smallest integer >= value Orac...

In Sql server we have a table sysobjects which holds names of all the tables i.e. system and user tables. Like the same we have command “Show tables” which show all the tables of specified database. Syntax Show Tables from <databasename> Here is an example. SHOW TABLES FROM MySql If you had already select a database you can only use Show tables to show all the tables in the database. For ex. Select database MySql and in Sql command window enter following text SHOW TABLES And click on Run. It will show all the tables which is avalible in the list