Sanjeeb Sarangi

This query is not working in sapdb. any help will be appreciated..

Tahnks & Regards

Rajeev

Please give me fast comment

Above query is not working in TOAD( Databse managemnet tool)any help will be appreciated.

Thanks

Vinod

Hi,

  Am creating a page with JSP/SQL. I have a list of all tables. i need to display all the fields of each tables. What is the SQL Query? OR Any other chance to do it??

select * from user_indexes where tablename='ABC';

one can also use sp_help tablename in sql

Good answer, Sanjeeb!!!

The "SELECT * FROM INFORMATION_SCHEMA.COLUMNS"

Simple enough that even I could do it!!!

I've tried other resources, and got a headache,

and any site with 'MSDN' in it would put me

into Quagmire city.

Keep up the good work.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS is not working in SQL server

SELECT * from syscolumns

WHERE id = object_id('yourtablename')

Can any One help me with the query which can give me the Tablename's and Colums names in which has a Specific Data.

Please.

SELECT * FROM table_one WHERE unique_column =

(SELECT unique_column FROM table_two WHERE id_column = 1)

SQL Query to list down the tables in database,

@Rajeev :

The SELECT * FROM master.INFORMATION_SCHEMA.COLUMNS is meant for YUKON.. if you are working on SQL Server 2000 this query will not help.

The equivalent query for 2000 is SELECT * FROM master..SysColumns.

Thank You.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

it works nice.

Good jobs

thanks

hi,

can  anyone tell me what is the SQL Query to list down all the tables from database

iam very new to this environment.

Any help will be appreciated.

Thanks in advance.

plz i need urgently

select * from all_tables

will list all the tables that the current user (with which you logged in) has access to.

select * from all_tables where owner = <schema_name>

will give the list of tables for the mentioned schema name (if you have access to it)

Good answer Keith, it works in sqlserver.

thank u.

Only Required to ListDown TableNAme

hi nice work....

code worked well to me

It's Working, Thanking U.

Thanks for showing me Query...

select * from user_tables

select * from all_tables

Try this...

To show all tables in a database:

$showTables = mysql_query("SHOW TABLES FROM $database");

To show the columns in a selected table in the database:

$fields = mysql_query("SHOW COLUMNS FROM $TableName");

PHP is used in here, but still the queries are working.

However, is there a single query that shows all columns or fields in a database without selecting a specific table anymore?

I need help. looking for code in SQL to show the list of the detail of and items in a specific table

select * from tab;

select * from user_objects where object_type = 'TABLE'

Try this one,

select * from sys.tables

SELECT distinct table_name FROM INFORMATION_SCHEMA.COLUMNS

This query will retrieve the table names

Thanks the query is worked for me to get the tables name in SQL

SELECT distinct table_name FROM INFORMATION_SCHEMA.COLUMNS

this is the correct qurey.this qurey shows exact

tables in the database

hi i am using asp.net with sqlserver ,i have more database in contain folder . i need to display all database into dropdownlistbox how this possible

          pls help me

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

SELECT * FROM INFORMATION_SCHEMA.TABLES

easy and simple

Try this

Select * from [dbname].[dbo].[tablename]

This works for me :-)

try this

select * from user_tab_columns

try this

select * from user_tab_columns

i want to execute a query on the whole database how i can do it?

How to get the tables count and name in one particular dsn/mdb using SQL Query, Please help

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

worked for me, thanks.  I'm no SQL expert and a vendor was telling me they couldn't get me a list of the fields in their product's database and that I should find some third-party utility.  Nope.  I was on the phone but I wish I could've seen their faces when I dumped the query results to a CSV and shared.

Thankyou so much for this post.Great Question and correct answer.

need a query to show all the databases on perticular instance of SQL Server

This link provides SQL query to display all columns with datatypes for a given Table name

www.besttechtools.com/SQLArticles.aspx

use YourDB go select * from sys.tables

"select * from table '" & txtTable.text & "'",

can i use this code??

"select * from table '" & txtTable.text & "'",

can i use this code??

I have tried in sql server 2008, and this is how it worked for me..

1) Select the required database.

2) Execute this query :

SELECT * FROM INFORMATION_SCHEMA.TABLES

Query for Number of schemas, names of schemas and tables for each schema in DatabBase using Toad.

how can i get tablename and columnname by passing value please give me the query

Happy man, happy cavil.