Define database objects
You can create data objects such as databases, schemas, tables, columns, primary keys, and foreign keys in the Data Definition view.
Restriction: There is currently no support for modeling indexes, check and unique constraints, triggers, structured types, or identity columns.In addition to importing and exporting data definitions, you can also create data definitions in the Data Definition view.
Copying data definitions into a project
You can copy a data definition from the Database Explorer view into a project in the Data Definition view. After you copy the data definition, you can then view the design and run queries on the database.Limitations for copying database definitions to a project
Some limitations apply when you copy a database definition from the Database Explorer to a project in the Data Definition view. Some of these limitations have workarounds.Defining a database
Define a relational database by using the New Database Definition wizard in the Data Definition view. A relational database is a set of tables that can be manipulated in accordance with the relational model of data. A relational database contains a set of data objects that are used to store, manage, and access data. Examples of such data objects are tables, views, indexes, functions, and stored procedures.Defining a schema
Define a schema to organize the tables and other data objects by using the New Schema Definition wizard. A schema is a collection of named objects. In relational database technology, schemas provide a logical classification of objects in the database. Some of the objects that a schema might contain include tables, views, aliases, indexes, triggers, and structured types. Define schemas to organize the tables and other data objectsDefining a table
Define a table by using the New Table Definition wizard. Tables are logical structures that are maintained by the database manager. Tables consist of columns and rows. You can define tables as part of your data definitions in the Data perspective.