If your Database Server is Microsoft SQL Server, you can use Visual Database Tools to visually design and modify the Database mode, create stored procedures and other database objects for Microsoft SQL Server6.5 and Oracle7.3.3 + databases, and add and browse database tables and view data, intuitively create SQL queries for any ODBC or OLE DB compatible databases, such as databases. You only need to create a Database connection in the project by using Microsoft's Visual Database tool, you can operate on database objects and query databases.
The database tool of Visual InterDev has the following features:
1. In the Data View window, expand the database object to browse the database;
2. When creating a new Database digoal, the Database will not be affected until you choose to store your design;
3. You can use Data View to create, update, or delete database objects, such as tables, views, and stored procedures;
4. Open the table to add data or select a design table, and perform complex database operations by changing the column data type;
5. Check and store the changes made to the SQL code in Database digoal. You can submit the changed scripts to the Database manager to review the execution of the controlled Database environment.
Query Desiner can be used to construct and execute any Query of ODBC-compatible databases in four different ways.
This article is prepared by the beach kiddies. You can reprint it, but please indicate its source. Thank you!
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.