SQL server command help and tutorials for specific commands?

Question

I saw the command in my book project (book - teach yourself SQL in 10 mins, 2004):

ALTER TABLE Customers WITH NOCHECK 
ADD CONSTRAINT PK_Customers PRIMARY KEY CLUSTERED (cust_id);

Can you tell me what these commands mean (or give links with simple tutorials for these commands) :

WITH NOCHECK
CLUSTERED

Are there any alternatives to the above commands? Can I remove them ?

I am using the free edition of SQL Server 2008 R2 with latest updates.

I tried this link- http://odetocode.com/articles/79.aspx But, it is very confusing. It does not explain the concept for a beginner. — superfast, Jun 09 '12 at 09:32

score 4 · Answer 1 · answered Jun 09 '12 at 03:41

4

You may download or use online book from MSDN.

answered Jun 09 '12 at 03:41

KV Prajapati

93,659
19
148
186

score 2 · Answer 2 · answered Jun 09 '12 at 03:41

2

WITH NOCHECK will tell SQL Server not to validate the particular constraint. CLUSTERED tells SQL Server to create a clustered index with the key cust_id. That will turn it from a heap to a clustered index.

answered Jun 09 '12 at 03:41

i dont understand what you said. I am a newbie. – superfast Jun 09 '12 at 09:18
LOL ! Unfortunately, my book uses those commands (to build the sample database) but does not even have notes for them. I cannot get another book immediately. Any good links/tutorials for these commands until i get another book ? – superfast Jun 10 '12 at 01:33

score 0 · Answer 3 · answered Jul 03 '12 at 20:00

There are plenty resources online. You can start here: It should have most of the basics covered. Start form the basics, such as create database, create tables, select data from tables, etc. More advanced topics such as clustered indexes and With Non-check option will make it more confusing for you.

SQL server command help and tutorials for specific commands?

3 Answers3