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 |
How many types of literals are available in pl sql?
What are the types of operators available in sql?
Are stored procedures faster than queries?
What does t sql mean?
Explain commit, rollback and savepoint.
Determine if oracle date is on a weekend?
what are the properties and different types of sub-queries? : Sql dba
what are the different types of joins?
what happens if you no create privilege in a database? : Sql dba
How do I view a sql trace file?
What is aggregate function in sql?
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);
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)