up

1. Browse table Information
2. Browse view information
3. Browse index information
4. Browse trigger information
5. Browse constraint information
6. Browse function information
7. Browse procedure information
8. Browse sequence information

1. Browse table information

DtSQL allows users to browse table information:

• Columns - select the 'columns' node of the table to show the table columns information

• Table DDL, primary keys and record count - select the 'Information' node of the table to show all these information.

• Table data - select the table node to show the table data

2. Browse view information

DtSQL allows users to browse view information: .

• View columns - select the columns node of the view to show the view columns
• View data - select the view node to show the table data
• View DDL - right click the view node and select 'Alter View' in the pop menu to show view DDL

3. Browse index information

DtSQL allows users to browse index information: .

• Index columns - select the index node to show the index column information
• Index DDL - right click the index node and select 'Alter Index' in the pop menu to show index DDL

4. Browse trigger information

DtSQL allows users to browse trigger information: .

• Trigger data - select the trigger node to show the trigger information
• Trigger DDL - right click the trigger node and select 'Alter Trigger' in the pop menu to show trigger DDL

5. Browse constraint information

DtSQL allows users to browse constraint information: .

• Constraint data - select the constraint node to show the constraint information

6. Browse function information

DtSQL allows users to browse function information: .

• Function data - select the function node to show the function information
• Function DDL - right click the function node and select 'Alter Function' in the pop menu to show function DDL

7. Browse procedure information

DtSQL allows users to browse procedure information: .

• Procedure data - select the procedure node to show the procedure information
• Procedure DDL - right click the procedure node and select 'Alter Procedure' in the pop menu to show procedure DDL

8. Browse sequence information

DtSQL allows users to browse sequence information:

• Sequence data - select the sequence node to show the sequence information