Dba Experts Unnara Mana Db Lo?

[maximummax]

Oka question

 

database lo tables unnai

each table has some number of columns

 

 

need a single query to display table name and column names of that table on a whole DB schema

[Suhaas]

SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME

 

Is this what you are looking for?

[krisomania2043]

calling KASAK

[Sirimalli]

ltt

[maximummax]

SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME

 

Is this what you are looking for?

table or view doesn't exists antundi man

[Suhaas]

table or view doesn't exists antundi man

 

which database using?

 

MS Sql server ki ayithey adhe query.

[Rebel890]

http://stackoverflow.com/questions/420741/getting-list-of-tables-and-fields-in-each-in-a-database

[CheGuevara]

Select table_name,column_name from all_tab_columns order by table_name.

If it for a particular user then usef where owner='USER'

[Suhaas]

MySql or postgresql ayithey use this

 

 

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'YOUR DATABASE' ORDER BY TABLE_NAME

 

 

[Suhaas]

Select table_name,column_name from all_tab_columns order by table_name.

If it for a particular user then usef where owner='USER'

 

ORACLE ayithey use this.

[macha]

which database using?

MS Sql server ki ayithey adhe query.

Oracle vadutunadu mama... aa error Oracle di.

[agora]

ltt

[ramu]

Use select * from dba_tab_columns where owner=ur schema name order by table_name

[Suhaas]

Use select * from dba_tab_columns where owner=ur schema name order by table_name

 

This for oracle as well. If you want to get the hidden columns as well use 'dba_tab_cols' instead of dba_tab_columns.

[srinivas.t]

set pages 0;

set lines 1000;

set long 2000;

Select table_name,column_name from all_tab_columns  where owner = '&&schema_name';

 

 

Try this and give the value for schema name when it is prompted.