Database table descriptions. Analyzing table structures with sp_help or sys.

Database table descriptions schema table_name; Postgres (psql): \d table_name; SQL Server: sp_help table_name (or sp_columns table_name for only columns) Oracle DB2: desc table_name or describe table_name; MySQL: describe table_name (or show columns from table_name for only columns) SAP Help Portal - SAP Online Help Jun 17, 2024 · DESCRIBE TABLE in MYSQL . Table visibility. minor_id = 0 AND td. This query returns a list of columns, their data types, and whether they allow NULL values. Quantitative data is in numeric form , which can be discrete that includes finite numerical values or continuous which also takes fractional values apart from finite values. News_Train: News items for training the model Jan 9, 2024 · Every point where a row and a column cross signifies a distinct piece of data. Thank you for your suggestions Mar 3, 2025 · Captions are succinct descriptions of text that generally appear at the beginning and end of a data table. ' + t. Then you can view table info with a query joining the sys. Oracle EBS data dictionary (FND tables) Oracle EBS is shipped with its own data dictionary on top of standard Oracle database system catalog. For example, for Delta tables, you can see the current reader and writer versions of a table. When you design a database table, the properties that are assigned to the table and the columns within the table will control the allowed data types and data ranges that the table accepts. The table description of each table is Oct 13, 2022 · Example of Describe Table in SQL. The rows run horizontally and represent each record. TABLE_NAME AS TableName, t. Divide your observations into paragraphs about different aspects of the data. 2 Table Physical Name: chorizon Table Label: Horizon Column Physical Name: hzname Column Label: Designation The concatenated string of four kinds of symbols (five data elements) used to distinguish different kinds of layers in the soil. Table SQL: SELECT c. To add a table description, click into the box below the table name. : mdc-data-table--sticky-header: Optional. the set of values permitted for the data element c. WORKBENCH RELATED TABLES. -----Predrag Stojic-----#CognosAnalyticswithWatson Jun 19, 2024 · Table: wc_tax_rate_classes; Source File; Since WooCommerce is a WordPress plugin, it makes use of many of the WordPress tables. COLUMNS AS col ON col. • Name of table/database • Title • Delivery class • Text table if appropriate • Field list • Key field indicator • Data element • Data type • Length • Check table • Field description • Includes • Link to full details about each field/data element/domain Add data to SAP database tables Description of SSURGO Database. The title should specify the information stored in the data table. It is a simple table that contains the id and name. Suppose, we have taken a table as demo to use the DESCRIBE. extended_properties table: Jun 14, 2017 · Moreover, we might know that a lot of tools with extended features, like ApexSQL Doc, that help a developer to document its SQL Server database objects use an extended property called MS_Description. So I want to put a description on each database. This will include, for each table: Descriptions of what the table means and how it's functionally used (in the UI, etc. Examples of SQL DESCRIBE TABLE. The most common example is a column in a data table that describes the row with which it intersects, and others include class variables in programming languages such as Java. Column Values 5. If one table has columns which are only apply if the row is of a certain type, consider splitting these out into subtypes; Again, identifying supertypes & subtypes is an iterative process. This is a simplified description of the most basic kind of table. News_To_Score: News items to score: dbo. As we will consider all objects inside the database, we should also consider getting back existing values from these extended properties. About sys. if the SDK documentation is already installed to your local PC you can locate the SDK documentation from this path C:\Program Files\SAP\SAP Business One SDK\Help\SDK_EN. DESCRIBE TABLE Schema Name. In psql command line tool, \d table_name or \d+ table_name to find the information on columns of a table. , Which of the following should not be used as a primary key in a table?, n a relational database table, columns are better known as and more. uid = t. Even with table descriptions and field names, you may have a hard time pulling the data you need, accurately, without a JDE expert to guide you. Look at the heading and any labels. Tables are the primary database objects that store data in a tabular format. major_id = t. Queryable tables are visible across all of Metabase. It offers a better way to view essential information about the columns within a specified table, such as the data type, nullability, and key constraints. I'm not sure of the data you are looking for. Welcome to SAP Tables The home of table descriptions for SAP's Enterprise Resource Planning systems ERP 6. As you build the database, you may find you need to split a table into subtypes. 1. Example of DESCRIBE TABLE This query returns a list of columns, their data types, and whether they allow NULL values. Column deleted in the database is represented by an icon. 3 HR Sample Schema Table Descriptions Consider the columns of each table of HR sample schema. Proper table design, will make it easier and faster to store Jun 25, 2018 · Create new diagram, add to it tables you want to edit and change view of table to Custom - right click table, select Table View and choose Custom. columns. DICOM Attribute Filter Jul 13, 2010 · The columns you will want to pull are TDPSEQ (sequence number), TDSQLC (field id), and FRDSCR (field description). They’ll have to spend less time trying to understand what you did at a certain step in your data cleaning or what a certain variable name means. Apr 10, 2014 · A relational database is made up of several components, of which the table is most significant. By doing this, you give yourself the best chance of understanding the table and its contents. Describing a table means getting information about the structure and metadata of the table. Click on "Table Inspector" to view detailed information. Oct 1, 2018 · Relational database engines enable much more description of data models and provide this information through their data dictionaries. Let‘s discuss some key ways table design impacts query execution. Before we get too far into the details, here it is parsing a table. Feb 4, 2025 · The data in the table can be compressed either by row or by page. identification of the user(s) responsible for changing values for the data element b. I would like to avoid creating N different table columns, one for each description. Document indexes are created on tables to improve query performance. name AS [table], td. DatabaseLog (1,597 rows) Audit table tracking all DDL changes made to the AdventureWorks database. value AS [table_desc], c. From the table page you will get details about each table and the fields of that table. uid LEFT OUTER JOIN sys. Modifier class name added to root element to make header row sticky (fixed) on vertical scroll. 2. Sep 27, 2024 · This query is useful for finding all auto-generated primary keys in our database. (SSM) Column Physical Name: desgndisc Column Label: Disc Sep 20, 2008 · 1) PostgreSQL DESCRIBE TABLE using psql. May 27, 2024 · SQL Server is a widely used Relational Database Management System (RDBMS) that allows users to create and manage databases effectively. object_id Well-documented data is more usable to others. sys. For more information, see Storage and SQL Server capacity planning and configuration (SharePoint Server). Thanks in advance. Therefore, to understand the structure of WordPress, please see the WordPress Database Description doc. Laurie The descriptions of most key columns and data columns contain references to the fields from which they are derived in the SMF record, such as From BRFFLRTY. Advanced Usage of DESCRIBE TABLE Using DESCRIBE TABLE for Database Analysis. Nov 18, 2024 · By adding descriptions, developers and database administrators can enhance the readability and maintainability of the database schema. value AS [column_desc] FROM sysobjects t INNER JOIN sysusers u ON u. Overall Structure of a Database Table. Understanding the information provided with this database can help you perform advanced functions such as creating a custom report. Data is captured by the database trigger ddlDatabaseTriggerLog. Each database description includes information about sizing and placement. DDLANGUAGE = language. When others are able to reuse your data, they can also cite your data! Benefits for others. Index Documentation. The HOLIDAYS_GROUP_DESCRIPTION table describes how holidays are grouped (by country for example) ID_TABLE: The ID_TABLE database table is used for unique identifier generation: INSTANCE_CERT_STORE: The INSTANCE_CERT_STORE table links a service to a client certificate for using SSL Mar 28, 2025 · A row in a database table represents a single entry and contains data corresponding to the columns in the table. They serve as a database to support various business processes and decision-making in materials management. User administration; Batch input queue; Job processing; Spool; Run-time errors; Message control; SAP EDI transactions: List of EDI Codes; Change documents; Reporting tree table; SETTINGS; MASTER DATA; INFOTYPES; SAP Tables for?Finance and Jan 8, 2025 · Databases use constraints to determine what types of tables can (and cannot) be stored and what types of data can live in the columns or rows of the database tables, for example. Name - Column name. May 23, 2011 · From the field you need to indentify the domain in se11, then you can goto se16, table name is DD01T. Or merge two tables into one. TABLE command on it and view Jun 17, 2024 · In the Navigator(that left side panel), locate and expand that database. Fill in the Description field for each column. extended_properties td ON td. Understanding your table structure is not just an academic exercise – it has real implications for database performance. Besides the standard role of basic user-defined tables, SQL Server provides the following types of tables that serve special purposes in a database Text13: Table Column Descriptions Text13: SSURGO 2. The data dictionary usually records and describes a default value, which is the _____. The data can be both quantitative and qualitative in nature. Technical Setup for Raw data; Raw data details (PCC) Introduction; Call and Agent Detailed Records; A few words about statistics; The Database Structure (Data Model) Database diagram; Table descriptions. The BigFix ® Remote Control Server program comes with a built-in database. File Status mapping. name + '. We convert it to JSON merely to make it easy to display. In the left pane of the screen that is displayed, expand the All Databases node and select the appropriate database to expand its objects tree, then select Tables. you can Identify the text. For example, by understanding which The column names used in the release files are the formally specified names and these should be used as the column names in the relevant database tables. columns is a system table and is used for maintaining information on columns in a database. Data compression can allow more rows to be stored on a page. sp_help is what you're looking for. Creating Students table: I am looking for documentation regarding Cognos Content store tables descriptions for v11. Types of Tables. dcm4chee2-user-guide. Production. Other names for rows are records or tuples. Represents the table, view, type, procedure, function, package or synonym you wish to describe. 2) PostgreSQL DESCRIBE TABLE using information_schema. It produces an object that describes the table. A data field is a location for a predetermined type of data that — collectively with other data fields — describes the place it is stored. Table Descriptions. Right-click on the table you want to describe. Related articles DESCRIBE FUNCTION; DESCRIBE QUERY; DESCRIBE SCHEMA; INFORMATION_SCHEMA. DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and bring peace to the world. Think of it as a list along with a description of tables, fields, and columns. For more information on which privileges allow access to another table in a different schema, refer to the Oracle Database SQL Language Reference. Each column in a database table should be assigned a data type by consistently by applying defined mappings between data types defined in SNOMED CT specifications 1 and Every column of every table has a description in this table : DBObjects: META: Every SkyServer database object has a one line description in this table : DBViewCols: META: The columns of each view are stored for the auto-documentation * means that every column from the parent is propagated. Example 1 - Students Table. Apr 16, 2020 · Here in this article I’ll introduce a PowerShell function that does the hard work. Each row in a table represents a single record or entity, while each column denotes an attribute or field of that record. These tables facilitate the organization, retrieval, and processing of data regarding procurement, inventory, vendor interactions, and other material-related activities. PK - Indicator if a column is part of primary key - icon. May 10, 2023 · So desc or describe command shows the structure of the table which include the name of the column, the data type of the column and the nullability which means, that column can contain null values or not. Don't use your own general knowledge to give reasons for the data or to add more information than is shown. MARA is the SAP Master data Table for Material. . value AS [COLUMN_DESCRIPTION] FROM INFORMATION_SCHEMA. 4. Mar 2, 2013 · If you specifically want to use INFORMATION_SCHEMA (as I was) then the following query should help you obtain the column's description field: SELECT COLUMN_NAME AS [Output] ,ORDINAL_POSITION ,prop. ORDINAL_POSITION AS Ordinal, c. access_points; agent_event_sources; agent_event_types; agent_result_codes; agent_events; agents; call_event_types; call_events; call HR Sample Schema Table Descriptions; 4. TABLE_NAME = tbl. Jan 25, 2025 · A data dictionary is a collection of metadata such as object name, data type, size, classification, and relationships with other data assets. Table Structure and Performance. columns AS sc ON sc. Tables are similar to a worksheets in spreadsheet applications. In the customer database example, each row in the table for customer information represents a different customer and their corresponding details, such as their phone number and address. Here is an incomplete list: sqlite3: . value for the data element if a value otherwise is not entered for it d. Simple Example using DESCRIBE TABLE command. These summaries describe the content of the table, which can make it easier to locate the file. Apr 1, 2014 · If you do a select of the metadata from all_tab_columns for that table present on the DBLink, it'll provide the description of the table. 3. Option 1 – Using the Administer Databases activity option In the left pane of the screen that is displayed, expand the All Databases node and select the appropriate database to expand its objects tree, then select Tables . Consists of the database link name corresponding to the database where object exists. Nov 26, 2008 · This is the code I use within the EntityFramework Reverse POCO Generator (available here). All of these features of the table are described at the time of Creation of the table. TABLE_SCHEMA AS SchemaName, c. You can create custom tables for use in JD Edwards EnterpriseOne applications. VBAK: Sales Document: Header Data. I converted the file abc to a SQL file and then run it - taking a spool before running the SQL file. DICOM Attribute Filter. name AS [column], cd. @ db_link. Analyzing table structures with sp_help or sys. The database table is where all the data in a database is stored, and without tables, there would not be much use for relational databases. Metrics: Metrics for the trained model: dbo. I have run the following command in SQLPLUS after taking a spool to file abc: select 'DESC ’ || table_name from user_tables; 2. The primary goal of a data dictionary is to help data teams understand data assets. Database Table Descriptions. For every column added in a database, a record is created in the sys. columns table. TABLES AS tbl INNER JOIN INFORMATION_SCHEMA. You are currently viewing the COMPANY database. Note that the posts tables is used by Custom Post Types, and WooCommerce uses those for products, coupons, and orders. The underlying HTML code of this table belies the necessary associations that make the table readable using a screen reading technology (Replace this caption with your own description of the table) Jan 29, 2017 · Table SAP MM TABLE; MAKT: Material Descriptions: MAPR: Material Index for Forecast: MARA: General Material Data: MARC: Plant Data for Material: MARD: Storage Location Data for Material: MARM: Units of Measure for Material: MAST: Material to BOM Link: MBEW: Material Valuation: MCHA: Batches: MCHB: Batch Stocks: MDBS: Material View of Order Item Columns tab displays a table of all table/view columns imported from the database. 4, running on Windows 7x Dec 2, 2024 · This article describes the databases that are installed for SharePoint Server. Certain considerations follow from this simplified description: Oct 11, 2024 · MIMIC-IV incorporates contemporary data and adopts a modular approach to data organization, highlighting data provenance and facilitating both individual and combined use of disparate data sources. 1. The columns run vertically and represent a specific field. The layout and properties of those fields, however, are specified by the table description. artists table stores artist data. For Ex: select * from all_tab_Columns@dblink where table_name='ASDF' and owner='XYZ'; Sep 9, 2022 · Object Object Area Table Name Table Description Relevant Primary Keys; BP – Customer: General Data (BP) BUT000: BP General Data: Business Partner (BP) BP – Customer Table description; Column header; Column; Row; Title. albums table stores data about a list of tracks. Then finally look at the data contained within it. The description of a data table can be added below Oct 8, 2023 · Database schema: The logical blueprint within the database that defines how data is organized and structured. dbo. Jul 3, 2012 · Study with Quizlet and memorize flashcards containing terms like Match each database object on the left to its description on the right. The question only requires you to summarise and report the data in the table. For example, by understanding which To get the description data, you unfortunately have to use sysobjects/syscolumns to get the ids: SELECT u. First, the choice of data types is Mar 13, 2019 · IBM Data Studio has some options for editing the description of tables in a DB2 database, as described next. 1 Apr 16, 2015 · Use the below to check the table description for a single table. Click on "Tables ". Database tables store the data that is used by applications in columns and rows. a. I also updated my DBeaver from 5. Nov 6, 2015 · The new section, some important Material Master Tables in SAP will detail with the condition to join. Option 1 – Using the Administer Databases activity option. DOMNAME = domain name. See Review Delta Lake table details with describe detail for the detail schema. 5 days ago · This section shows you how to add descriptions of a table and its columns and records to a Dataform core SQLX file. 2. This information is: Data type of column, Default values for columns, Nullability of columns, Table relationships (foreign keys), Uniqueness of column values (primary and unique keys), Data elements descriptions Nov 11, 2023 · This issue becomes more pronounced when table and column descriptions, along with sample data, are added — particularly for categorical and string data types. The syntax may vary slightly depending Sep 13, 2023 · The next step is to fetch columns for these tables. Each album belongs to one Jul 8, 2020 · Raw Data. Dependency: META: Contains the detailed inventory of Dec 16, 2013 · Database Schema Diagram. Change Sep 21, 2021 · Hello, The new version of DBeaver will show Table Description empty at IBM DB2 As 400 It happens at the version after 12. Can anyone tell me where can i get these descriptions? Actually my requirement is i need to get the descriptions for the transaction VK15 key combination? Like SalesOrg/Material Sep 18, 2024 · Example: Creating a Table with Constraints. Avudaiappan Nov 13, 2014 · what is the best way to store these product descriptions in a database table so they can be displayed in a "description" Tab of a dynamic product page. Data dictionary tables; Workbench; ADMINISTRATION. The invoices table stores invoice header data and the invoice_items table stores the invoice line items data. Include information such as the table name, purpose, list of columns with the data types and constraints, primary key, foreign keys, and any additional notes. id AND td. Nov 26, 2015 · Cross-reference table mapping product descriptions and the language the description is written in. The table data is the part users often think of as comprising the database, because it contains the actual records with their data fields. We've created scripts that generate SQL commands adding your table, view and column descriptions to either SQL Server extended properties or Oracle DB comments. # - Column position in a table (imported from the database). Let's see the visual representation of How to Display Table Information in MySQL Workbench. invoices & invoice_items tables: these two tables store invoice data. I cannot overemphasise the importance Oct 1, 2018 · There is a solution to this - second data dictionary - FND tables. For example, a company’s data table containing its employees' details can be named as employee_information_table. Create a document or spreadsheet to describe each table in detail. It is accessible through tables in FND schema. Model: Trained model: dbo. The SSURGO database contains information about soil as collected by the National Cooperative Soil Survey over the course of a century. 0 (EHP7) and Business One IS-M/SD: WBZ, Order Data for Mar 9, 2011 · A simple approach to document table columns is to use the SQL Server Management Studio table designer. tables with sys. TABLE_NAME INNER JOIN sys. Types of Data. Eclipse Development Environment. The rows and columns intersect, forming a grid. Deploying multiple archive instances. name = 'MS_Description' INNER JOIN Mar 12, 2025 · Return information about schema, partitioning, table size, and so on. From Sybase online documentation on the sp_help system procedure: . The Oracle's JD Edwards EnterpriseOne system uses a relational database. Option 4: Description property in the designer Mar 25, 2015 · I use SQL Server Express 2012 and have multiple SQL Server databases and sometimes it gets difficult to find out which is which. Think about the categorise provided. Every cell in Students table has a data item that represents a particular student attribute, such as ID, NAME, AGE, or COURSE. The table descriptions are as follows: CUSTOMERS: This table stores the customer's name and mailing address, plus the name of the person who referred that customer to the The above relational diagram represents a book store database. By default, the database provides several tables that contain a variety of target and user information. Each column is a data item, and each row is a record. Welcome to the DynDeveloper GP Table reference The best table reference for Dynamics GP anywhere. Description. For table short texts you can refer table - DD02T. Dec 7, 2024 · Database records and files must be organized to allow retrieval of the information. The root DOM element containing table and other supporting elements. Creating a Table or Defining the Structure of a Table To get the description data, you unfortunately have to use sysobjects/syscolumns to get the ids: SELECT u. COLUMNS Aug 30, 2023 · Thus, the SQL DESCRIBE TABLE is beneficial for fetching out details about the current table present in the database. Let’s create the Employees table again, but this time with additional constraints to enforce data integrity:. You might want to document the following: The purpose of the table. Table Prefix Columns Indexes Description Type Report Category; 1: F4211: SD: 268: 19: Sales Order Detail File: Transaction Files: 42: Sales Management: 2: F0101: AB Database Table Descriptions. 5 to 5. Label_Names: Names associated with each of the 20 labels: dbo. SELECT statement to query the column_names,datatype,character maximum length of the columns table in the information_schema database; Table caption (name and description of table) This is an example of a Complex Data table that associates column headers with row headers that span multiple rows. Jun 7, 2017 · It depends from the database you use. Creating a Table with Column Descriptions. The power of a DBMS comes from its ability to define new relationships from the basic ones given by the tables and to use them to get responses to queries. It is a part of database and contains various fields. Let dive in and see a few examples of DESCRIBE query in SQL. The DESCRIBE TABLE statement, also commonly written as DESC TABLE or DESCRIBE, is a MySQL command used to retrieve metadata about a table. Each column in a table is associated with a specific data type that defines the kind of data it can store. 0. tables and syscat. Queries are the main way users retrieve database information. Open edit dialog for Custom view and then add a Description field to your view. Oct 16, 2024 · This article examines a sophisticated Python script that combines metadata extraction from SQL CREATE TABLE statements with Google's… Tables are used to store data. To add descriptions to columns when creating a table, you can use the SQL CREATE TABLE statement along with the COMMENT clause. Table Name join the below tables to check the table description for a multiple tables, join with the table id syscat. A database consists of one or more tables. Those tables hold additional information: descriptions of tables, views A table consists of an ordered arrangement of rows and columns. May 24, 2021 · To understand the table, take a sensible approach: Read the description first for clues. Also, the main Customizing SAP MM Tables for Materials (for SAP Material Category and Material Type) SAP Material Master Tables Details General Material Data Table: MARA. The information can be displayed in tables or as maps and is available for most areas in the United States and the Territories, Commonwealths, and Island Nations served by the Table description. specification for the origination point for Thanks to the open access to our repository you can do it by yourself right now. MIMIC-IV is intended to carry on the success of MIMIC-III and support a broad set of applications within healthcare. Given below are the examples of SQL DESCRIBE TABLE: Example #1. COLUMN_NAME AS ColumnName, CAST(CASE WHEN IS_NULLABLE = 'YES' THEN 1 ELSE 0 END AS BIT) AS IsNullable, DATA_TYPE AS TypeName, ISNULL(CHARACTER_MAXIMUM_LENGTH, 0) AS CSS Class Description; mdc-data-table: Mandatory. Reports information about a database object (any object listed in sysobjects) and about system or user-defined datatypes, as well as computed columns and function-based indexes. Good documentation makes your data more useful to others. 0 and v11. Hidden tables won’t show up in the query builder or data reference. Jan 26, 2012 · hi Harley, Clint is correct! to make this document available to your local computer you need to install the SDK Documentation accompanied in your installer. CREATE TABLE Employees ( EmployeeID INTEGER PRIMARY KEY, -- Unique identifier for each employee FirstName VARCHAR(50) NOT NULL, -- First name of the employee (cannot be NULL) LastName VARCHAR(50) NOT NULL, -- Last name of the employee Mar 7, 2018 · You can create up to 2,147,483,647 tables in a database, with up to 1024 columns in each table. For an explanation of such fields, refer to the applicable product documentation. For more information, see Data Compression. Jul 28, 2016 · BASIC DATA / ADMINISTRATION. This can be done by joining sys. Every data table should have a title. TABLE_TYPE AS TableType, c. ProductPhoto (101 rows) Product images. Thanks ! E. columns based on object_id for the database tables. Student table in the following example stores ID, name, mentor_id, birth_year, and percentage as the data of the students. A string containing a table (it could be a database of tables) is passed to the function. So far my search turned up only old Cognos 8 descriptions, but they don't seem to match. ) Descriptions of what each attribute means, if it isn't obvious May 20, 2024 · 3. Use a variety of structures for: Nov 7, 2018 · Over the past week, we've migrated a DB2/400 database from a private server with v6r1 to a cloud-based server/service with v7r3. You can add table, column, and record descriptions to all table types in Dataform: tables, incremental tables, and views. And enjoy the ability to edit descriptions in a table. Table of columns has following columns: Icon - Icon of a column. Data Types. In this section you can browse the list of SAP tables and their fields by Software components & modules wise. What you get. name = 'MS_Description' INNER JOIN Mar 24, 2015 · For my money, some good human-readable documentation (perhaps supplemented with diagrams of smaller portions of the system) will give you the most mileage. Tables are related using common key fields. These constraints are important because they ensure data is structured, less corruptible by unsanctioned data structures and that the database is regulated so users May 27, 2016 · A database table is a structure that organises data into rows and columns – forming a grid. Jul 21, 2020 · It summarizes the data in a meaningful way which enables us to generate insights from it. Sep 16, 2008 · Does anyone have any idea - is there any table that stores the descriptions of the tables? Example: MARA: General Material Data. News_Test: News items in the test set: dbo. Descriptions are displayed in Metabase’s data reference to help people find the right table for their use case. Column Data Types. columns helps identify relationships and optimization opportunities within your database. Table Description; dbo. A concluding paragraph is not always necessary. Table description. chm, or alternatively Start -->> SAP Business One -->> SDK -->> SDK Mar 4, 2024 · A table consists of two parts: the table data and a table description. When working with databases in SQL Server it is essential to understand the schema of the tables present in the database. Nov 7, 2023 · If your Harvest database is on the Oracle DBMS you can use this SQL*Plus script to generate table and column descriptions for any version of Harvest: column table_name new_value tblnm noprint column table_comments new_value tblcom noprint Nov 11, 2014 · Dear dxperts, I need to get the list of table description of each table in Oracle database under a particular schema. rnksk hvlwgan sfee dgtf vbfssk mtkhu efdlfgm fqzs urecbcfl yoph ybezzws myqw ohzs lms kgmnxv