SQL

Closed
raylop1 Posts 1 Registration date Friday 22 April 2016 Status Member Last seen 22 April 2016 - 22 Apr 2016 à 12:54
 Blocked Profile - 17 Oct 2016 à 18:07
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

3 responses

Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
22 Apr 2016 à 15:32
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.
sandra_diaz Posts 1 Registration date Monday 5 September 2016 Status Member Last seen 17 October 2016
17 Oct 2016 à 05:38
Hii,!!!!
Try below-listed command:-

Syntax:
SELECT column_name
FROM table_name;

Example:
SELECT PRODUCT
FROM Table_Name
Blocked Profile
17 Oct 2016 à 18:07
You could always connect to it,with SQuirreL and view it!

It's kind of fun to do the impossible! -Walter Elias Disney