Viewing your database structure
After connecting to your database, you can view its structure within .
For example, you can view the names of the tables, columns, views, and stored
procedures in the database. also identifies the primary key of each
table, and the data types of each column. You can even view the data stored
in your database tables.
To view the structure of a database:
Open the Databases panel (Window > Databases).
populates the Databases panel with all the databases for which connections
have been created. If you’re developing a ColdFusion site,
populates the panel with all the databases for which data sources have been
defined in ColdFusion Administrator.
Note: looks at the ColdFusion server you defined for the current site. See Specifying where dynamic pages can be processed.
If no database appears in the panel, you must create a database connection. For more information, see Connecting to a database.
To display the tables, stored procedures, and views in the database, click
the plus (+) icon beside a connection in the list.
To display the columns in the table, click a table name.
The columns icons reflect the data type and also indicates the primary key.
To view the data in a table, right-click (Windows) or Control-click (Macintosh) the table name in the list and choose View Data from the pop-up menu.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100