how to get a list of columns in an existing table? : Sql dba



how to get a list of columns in an existing table? : Sql dba..

Answer / Rajesh Kumar Gautam

"To get a list of columns (or fields) in an existing SQL table, you can use the DESCRIBE or COLUMNS command. The general syntax for both commands is similar:
```
DESCRIBE table_name;
COLUMNS FROM table_name;
```
Both commands will return a list of columns (fields) along with their data types, lengths, and other characteristics."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How many types of literals are available in pl sql?

1 Answers  


What are the types of operators available in sql?

1 Answers  


Are stored procedures faster than queries?

1 Answers  


What does t sql mean?

1 Answers  


Explain commit, rollback and savepoint.

1 Answers  


Determine if oracle date is on a weekend?

1 Answers  


what are the properties and different types of sub-queries? : Sql dba

1 Answers  


what are the different types of joins?

4 Answers   Choice Solutions,


what happens if you no create privilege in a database? : Sql dba

1 Answers  


How do I view a sql trace file?

1 Answers  


What is aggregate function in sql?

1 Answers  


how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,


Categories