Report

SQL

Ask a question raylop1 1Posts Friday April 22, 2016Registration date April 22, 2016 Last seen - Last answered on Oct 17, 2016 06:07PM
I used the below command to view the tables, but I need the command to see each individual table to see how they are build each;

SQL> Select table_name from user_tables;

TABLE_NAME
------------------------------
PRODUCT
DEPARTMENT
JOB
CUSTOMERS
EMPLOYEE
JOB2
DEPARTMENT2
INVOICE
INVOICELINE
See more 
Helpful
+0
moins plus
Hi raylop1,

You can use sp_help [TableName] to get the Detailed Structure of any table in your Database. For example: for your PRODUCT table you can use:

sp_help [PRODUCT]

This will return the Detailed Structure of [PRODUCT] Table.

Please let us know if this was helpful.
Add comment
Helpful
+0
moins plus
Hii,!!!!
Try below-listed command:-

Syntax:
SELECT column_name
FROM table_name;

Example:
SELECT PRODUCT
FROM Table_Name
Add comment
Helpful
+0
moins plus
You could always connect to it,with SQuirreL and view it!

Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!