SQLSERVER and ORACLE IMPORTANT Queries

 SQLSERVER and ORACLE IMPORTANT 

EXEC sp_columns 'dbo.tablename';

EXEC sp_help 'dbo.tablename';

SELECT column_name FROM information_schema.columns WHERE table_name = 'tablename' AND table_schema = 'ETL'

SELECT DB_NAME() AS CurrentDatabaseName;

SELECT name AS CurrentDatabaseName

FROM sys.databases

WHERE database_id = DB_ID();

oracle:-

SELECT DBMS_METADATA.get_ddl ('TABLE', 'tablename','HR') from dual;