DESC / DESCRIBE
Table
You
can verify if your table has been created successfully by looking at the
message displayed by the SQL server, otherwise you can use DESC/ DESCRIBE
command as follows:
SQL> DESC CUSTOMERS;
+-------------+------------------+------------+----------+------------+-----------+
|
Field | Type | Null | Key | Default
| Extra |
+-------------+------------------+------------+----------+------------+-----------+
| ID
| int(11) | NO
| PRI | | |
|
NAME | varchar(20) | NO | | | |
| AGE
| int(11) | NO |
| | |
|
ADDRESS | char(25) | YES | | NULL | |
|
SALARY | decimal(18,2) | YES | | NULL | | |
+-------------+------------------+------------+----------+------------+-----------+
5 rows
in set (0.00 sec)
Now,
you have CUSTOMERS table available in your database which you can use to store
required information related to customers
0 Comments