Report

SQL

Ask a question raylop1 1Posts Friday April 22, 2016Registration date April 22, 2016 Last seen - Last answered on Oct 17, 2016 at 06:07 PM by ac3mark
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.
Leave a comment
Helpful
+0
moins plus
Hii,!!!!
Try below-listed command:-

Syntax:
SELECT column_name
FROM table_name;

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

Leave a 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!