Databases

To get all indexes in SQL Server, use below query. SELECT TableName = t.name, IndexName = ind.name, IndexId = ind.index_id, ColumnId = ic.index_column_id, ColumnName = col.name, ind.*, ic.*, col.* FROM sys.indexes ind INNER JOIN sys.index_columns ic ON  ind.object_id = ic.object_id and ind.index_id = ic.index_id INNER JOIN sys.columns col ON ic.object_id = col.object_id and ic.column_id = col.column_id INNER JOIN sys.tables t ON ind.object_id = t.object_id WHERE ind.is_primary_key = 0 AND t.is_ms_shipped = 0 ORDER BY t.name, ind.name, ind.index_id, ic.index_column_id;

There is no query to get the description of the table like in MySQL. Use  sp_columns stored procedure to describe the table in SQL Server.            exec sp_columns tableName; And also we can use sp_help to describe the table. sp_help is returned depend on whether name is specified, when it is specified, and what database object it is.            exec sp_help tableName;          

Below steps are used to connect to various databases using Oracle SQL Developer. Install Oracle SQL Developer from the Oracle website here By default, it can be able to connect with Oracle database. So no explanation needed. Before connect to databases, need to configure the drivers for the databases into the Oracle SQL Developer. Go to Tools > Preferences > Third party JDBC drivers , configure all the drivers here. For Microsoft SQL Server, follow below steps to configure. Download jtds jar file from here In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers. Give all credentials in the SQLServer tab and click the Retrieve database which is like in this image  For MySQL, follow below steps to configure. Download MySQL connector from  here   In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers. Give all credentials in the MySQL tab and click the Retrieve database which is like in this image...

To backup the database, use below query. Backup database <databaseName> to disk ='<backupLocation>.bak' with init; To backup the logs, use below query. Backup log <databaseName> to disk =' <backupLocation> .trn' with init; To restore from the database backup, use below query. restore database <databaseName> from disk = <backupLocation>.bak ' with norecovery, replace, move 'testmirror' to 'DATA.mdf', move 'testmirror_log' to 'DATA_log.ldf'; To restore from the transaction log, use below query. restore log <databaseName> from disk =' <backupLocation> .trn ' with recovery, replace, move 'testmirror' to 'DATA.mdf', move 'testmirror_log' to 'DATA_log.ldf'

To view the unique constraints in MySQL database, use below queries select * from information_schema.TABLE_CONSTRAINTS where CONSTRAINT_SCHEMA = '<dbName>' and constraint_type = 'UNIQUE';

To find the created date time of the SQL server, execute the below query. SELECT create_date FROM sys.databases WHERE name = '<dbName>';

To find database size (GB) in Oracle, use below query. select round((sum(bytes)/1048576/1024), 2) from v$datafile;