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;
