SQL Server Tutorials

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 …

Learn more

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 …

Learn more

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 …

Learn more

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 …

Learn more

How to add text annotations to SQL Server database diagrams

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.

Learn more

How to duplicate table with SQL Server Object Explorer

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 …

Learn more

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 …

Learn more

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 …

Learn more

How to save the database diagram in SQL Server Object Explorer

Developers can save all the changes they made to a database diagram, including any changes they made to the tables, columns, and other database objects, by saving it. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to save the database diagram, they should follow the next steps:

Learn more