Microsoft MSSQL

Friday, March 28, 2008

It's not readily known but most definitely possible. You can change a table's name in Microsoft SQL Server by running the following sql:

sp_rename 'OLD_Name','NEW_Name'

MS SQL Commands

delete a table in ms sql
ALTER TABLE DCP_USER_ROADMAPS DROP COLUMN TREE_ID

Delete a foreign key
ALTER TABLE DCP_USER_ROADMAPS DROP FOREIGN KEY USER_ROADMAPS_TO_TREE_FK

Delete an index
drop index DCP_USER_ROADMAPS.USER_ROADMAPS_TO_TREE_FK

Create An Index
create index USER_ROADMAPS_TO_TREE_FK on DCP_USER_ROADMAPS (
ROADMAP_ID ASC)

Create A Foreign Key
alter table DCP_USER_ROADMAPS
add constraint FK_DCP_USER_USER_ROAD_DCP_TREE foreign key (ROADMAP_ID)
references DCP_TREE (TREE_ID)
on delete cascade

Labels: Technology