Developers modify a unique constraint when they want to change the columns that the constraint is attached to, change the constraint name, or set additional properties for the constraint. In this case they should follow the next steps:
1. In their database diagram, right-click the table containing the constraint, then select Indexes/Keys …
How to rename columns in a table in SQL Server Table Designer
Developers can use SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 Table Designer to rename a column directly in their tables, by following the next steps:
1. In Object Explorer, right-click the table with the columns they want to rename and choose Design (Modify in SP1 or earlier). The table opens in …
How to modify the data type of a column in SQL Server Table Designer
Developers can modify the data type of a column in Table Designer. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to modify the data type of a column, they should follow the next steps:
1. In Object Explorer, right-click the table with the columns whose data types …
How to create a new database diagram in SQL Server Object Explorer
Developers use Object Explorer to create new database diagrams. Database diagrams graphically show the structure of the database. Developers can use diagrams to create and modify tables, columns, relationships, and keys. Additionally, they can modify indexes and constraints. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to create …
How to add an existing table to a SQL Server database diagram
Developers can add a table to their database diagram to edit its structure or relate it to other tables in their diagram.. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to add an existing table to a diagram, they should follow the next steps:
1. Make sure …
Developers can make notes or comments on a database diagram, by adding text annotations. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to add text annotations to diagrams, they should follow the next steps:
1. Open the diagram to which they want to add an annotation.
Developers can use Object Explorer in SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 to duplicate only the structure of an existing table, without any table rows, by following the next steps:
1. Check if they are connected to the database in which they want to create …
How to copy column definitions from one table to another in SQL Server
When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to copy column definitions from one table to another, they should follow the next steps:
1. Open the table with columns they want to copy and the one they …
How to create a new query in SQL Server Query and View Designer
Developers can use queries to retrieve data from the tables and views in their database. They can create and work with queries in Query and View Designer, which is composed of four panes: the Diagram Pane, the SQL Pane, the Criteria Pane, and the Results Pane. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 …
How to create a full-text search query in SQL Server Solution Explorer
Full-text searches use the CONTAINS predicate to locate rows that have specified text in a given column. Full-Text searches are only possible on columns that have active full-text indexes. If developers attempt to use the CONTAINS clause on a column that does not have a currently active full-text index, they will receive an error.When developers working with SQL …