Hello friends, sql server management
In this article I will tell you how to create an Index using the SQL Server 2008 Management Studio tool. I would recommend reading the previous article for detailed information about Index. In that article, I explained by example how the index concept is and I showed you how Index works. If you do not know about Index before reading this article, please read it. sql server management
I have written this article for those who do not know the new History T-SQL in SQL Server a lot of the Database admins. Now, step by step, using the SQL Server 2008 Management Studio TOOLSUN I will create a sample table and display it on any column on that table. I will use the AdventureWorks database in here as usual. I first open SQL Server Management Studio and connect to Test instance I as follows. sql server management
In the first step above, right click on the Tables menu under the AdventureWorks database and click on New Table. When the last table is completed, if we try to save it as Ctrl-S, SQL Server will ask for the name of the table as in the second part, and if we enter it, it will be a table named IndexDeneme under DBO schema in AdventureWorks database. sql server management
After this step, we find the index table we created under the Tabs Tab, click the + tab and right click on the Indexes tab and try to create an index like New Index. sql server management
In this article I will show you how to create a Clustered Index, so I choose Index Type In as Clustered as shown below. I set the Index name to ClusteredIndexDename. Only one and only one Clustered Index can be created on a tablarda, but many Non Clustered Indexes can be created. I will choose this tabloda for Id column unu Clustered Index. I add the Clustered Index and Id Column unu by saying ADD as shown below. sql server management
In this article I will tell you how to create an Index using the SQL Server 2008 Management Studio tool. I would recommend reading the previous article for detailed information about Index. In that article, I explained by example how the index concept is and I showed you how Index works. If you do not know about Index before reading this article, please read it. sql server management
I have written this article for those who do not know the new History T-SQL in SQL Server a lot of the Database admins. Now, step by step, using the SQL Server 2008 Management Studio TOOLSUN I will create a sample table and display it on any column on that table. I will use the AdventureWorks database in here as usual. I first open SQL Server Management Studio and connect to Test instance I as follows. sql server management
In the first step above, right click on the Tables menu under the AdventureWorks database and click on New Table. When the last table is completed, if we try to save it as Ctrl-S, SQL Server will ask for the name of the table as in the second part, and if we enter it, it will be a table named IndexDeneme under DBO schema in AdventureWorks database. sql server management
After this step, we find the index table we created under the Tabs Tab, click the + tab and right click on the Indexes tab and try to create an index like New Index. sql server management
In this article I will show you how to create a Clustered Index, so I choose Index Type In as Clustered as shown below. I set the Index name to ClusteredIndexDename. Only one and only one Clustered Index can be created on a tablarda, but many Non Clustered Indexes can be created. I will choose this tabloda for Id column unu Clustered Index. I add the Clustered Index and Id Column unu by saying ADD as shown below. sql server management
0 yorum:
Yorum Gönder