May 21, 2002 at 1:34 pm
I have an Oracle background. I need to do something really quick on a SQL server for a project.
Can someone tell me the basic codes or point me to a resource on the web to:
Remove/Create a foreign key constraint
Remove/Create a composite primary key
Remove/Create an index
Set default value for a field
More questions are to come but you know where I am now. Thanks in advance!
May 21, 2002 at 4:49 pm
Honestly I think Books Online is the best bet for this stuff, since its the syntax you need. If you are working without SQL at the moment, http://www.msdn.microsoft.com has everything that is in BOL and more.
Andy
May 21, 2002 at 6:19 pm
Thanks Andy. I just found out that I can perform these simple tasks using diagram/save change to script.
Still searching for some sample stored procedures though. Oh and my books onlines that came with SQL Server client doesn't have any syntax tutoring parts to it. Odd.
May 21, 2002 at 6:26 pm
You can find them in the download section of http://www.microsoft.com/sql just make sure to download SQL 7s if you are running it and not 2000 as it does have a number of differences. TO find a sample of a stored procedure look in the scripts section of this site as there are many stored procedures there. Anything specific you need to know just post back.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply