![]() ![]() EXEC sp_help tablename įor example, we can run it on the customer table: EXEC sp_help customer You can call the sp_help procedure to see information about a table. However, there are two methods you can use to find similar information. There is no DESCRIBE command in SQL Server. So, in Oracle, the DESCRIBE or DESC command can be used. We could alternatively run the DESC command, as DESC is the same as DESCRIBE. ![]() We can see the column names of each column in the table, whether it has a NOT NULL constraint, and the data type. Here’s an example on a table called “customer”: DESCRIBE customer This can be run at a command prompt (like SQL*Plus or sqlcl) or in SQL Developer. This is what the DESCRIBE command looks like: DESCRIBE In Oracle, to describe a table we use the DESCRIBE command.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |