Click here to Skip to main content
14,359,426 members
   

Database

 
QuestionDATABASE Maintainance Pin
ricardobrooks6-Aug-18 4:12
memberricardobrooks6-Aug-18 4:12 
AnswerRe: DATABASE Maintainance Pin
Victor Nijegorodov6-Aug-18 9:01
memberVictor Nijegorodov6-Aug-18 9:01 
AnswerRe: DATABASE Maintainance Pin
Eddy Vluggen6-Aug-18 9:15
mveEddy Vluggen6-Aug-18 9:15 
GeneralRe: DATABASE Maintainance Pin
CHill606-Aug-18 23:01
protectorCHill606-Aug-18 23:01 
Questionrecovery method for hard drive Pin
Member 139376004-Aug-18 5:08
memberMember 139376004-Aug-18 5:08 
AnswerRe: recovery method for hard drive Pin
Victor Nijegorodov4-Aug-18 21:34
memberVictor Nijegorodov4-Aug-18 21:34 
QuestionNeed to drop a schema in which there are some objects exist Pin
indian1431-Aug-18 7:28
memberindian1431-Aug-18 7:28 
AnswerRe: Need to drop a schema in which there are some objects exist Pin
Mycroft Holmes1-Aug-18 16:03
memberMycroft Holmes1-Aug-18 16:03 
I'm almost certain you can't have a table with no schema so dropping a schema with existing tables should not be possible. I have no idea if it is because it seems so obvious that you should not do this, I have never tried it.

You can move table to another schema and then drop the schema, caveat the transfer does not change the views and procedures referencing the dropped schema. Did this recently, thankfully it was a small database.
Never underestimate the power of human stupidity
RAH

AnswerRe: Need to drop a schema in which there are some objects exist Pin
CHill602-Aug-18 3:26
protectorCHill602-Aug-18 3:26 
QuestionRe: Need to drop a schema in which there are some objects exist Pin
CHill606-Aug-18 2:40
protectorCHill606-Aug-18 2:40 
GeneralLegacy software: can't load MSJTER35.DLL Pin
Keith Sheppard228-Jul-18 0:26
memberKeith Sheppard228-Jul-18 0:26 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Victor Nijegorodov28-Jul-18 0:45
memberVictor Nijegorodov28-Jul-18 0:45 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Keith Sheppard22-Aug-18 2:23
memberKeith Sheppard22-Aug-18 2:23 
Questioninner join results Pin
Member 1386716325-Jul-18 19:12
memberMember 1386716325-Jul-18 19:12 
AnswerRe: inner join results Pin
Richard Deeming26-Jul-18 2:50
mveRichard Deeming26-Jul-18 2:50 
AnswerRe: inner join results Pin
Victor Nijegorodov26-Jul-18 2:54
memberVictor Nijegorodov26-Jul-18 2:54 
QuestionCreation of documentation automatically when creating or updating a stored procedure Pin
indian14323-Jul-18 14:49
memberindian14323-Jul-18 14:49 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
Victor Nijegorodov24-Jul-18 11:12
memberVictor Nijegorodov24-Jul-18 11:12 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
jschell28-Jul-18 8:13
memberjschell28-Jul-18 8:13 
QuestionJob runs 3 times longer Pin
VK1920-Jul-18 8:12
memberVK1920-Jul-18 8:12 
AnswerRe: Job runs 3 times longer Pin
Victor Nijegorodov20-Jul-18 9:01
memberVictor Nijegorodov20-Jul-18 9:01 
AnswerRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 1:16
mveEddy Vluggen28-Jul-18 1:16 
GeneralRe: Job runs 3 times longer Pin
jschell28-Jul-18 8:14
memberjschell28-Jul-18 8:14 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 11:23
mveEddy Vluggen28-Jul-18 11:23 
GeneralRe: Job runs 3 times longer Pin
digimanus14-Aug-18 4:01
memberdigimanus14-Aug-18 4:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.