How to create and drop a table outside of SQL
How to create and drop a table outside of SQL, that is, I have a table that I need to change fields, include fields and for this I need to drop the old one, create a new one to load it and save the other table as historical. I can either drop or create this table. Would you like to know the best solution to continue with this maintenance in an application? Thank you very much in advance. An XML or other form ... I dont know.
sql
edited Jan 10 at 23:48
Pathfinder
1,043817
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
|
show 1 more comment
How to create and drop a table outside of SQL, that is, I have a table that I need to change fields, include fields and for this I need to drop the old one, create a new one to load it and save the other table as historical. I can either drop or create this table. Would you like to know the best solution to continue with this maintenance in an application? Thank you very much in advance. An XML or other form ... I dont know.
sql
edited Jan 10 at 23:48
Pathfinder
1,043817
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
1
If you were to explain what you're actually trying to accomplish, and perhaps the context within which that requirement operates, we may be better able to suggest a solution. Right now you're using SQL terms (create, drop) to describe a circumstance you have explicitly stated will occur without SQL, so it's not particularly clear what you want.
– music2myear
Jan 10 at 21:56
There are many SQL-compliant databases, from Oracle to Firebird. Each is different.
– DrMoishe Pippik
Jan 10 at 22:49
I have an application with SQL database. One of the tables I do periodic maintenance . It has rates. Now and then I need to create new columns and for this I need to back up this table, drop it and recreate it. The application will be migrated to a new server where it will be prohibited to perform this routine maintenance on it. So, I would like to know how I can solve this by implementing directly in the c # / aspnet application. web.Does have on WEB anything to this issue?
– Joelias Andrade
Jan 10 at 23:49
Can you try to alter the table and add the column and ensure your SQL login has appropriate permissions to do so. You could run something likeALTER TABLE <table> ADD <column> VARCHAR(20) NULL
– Pimp Juice IT
Jan 10 at 23:57
Can I do it by frontend app?If it is possible, how can i do it?
– Joelias Andrade
Jan 11 at 0:12
|
show 1 more comment
How to create and drop a table outside of SQL, that is, I have a table that I need to change fields, include fields and for this I need to drop the old one, create a new one to load it and save the other table as historical. I can either drop or create this table. Would you like to know the best solution to continue with this maintenance in an application? Thank you very much in advance. An XML or other form ... I dont know.
sql
edited Jan 10 at 23:48
Pathfinder
1,043817
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
How to create and drop a table outside of SQL, that is, I have a table that I need to change fields, include fields and for this I need to drop the old one, create a new one to load it and save the other table as historical. I can either drop or create this table. Would you like to know the best solution to continue with this maintenance in an application? Thank you very much in advance. An XML or other form ... I dont know.
sql
sql
edited Jan 10 at 23:48
Pathfinder
1,043817
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
edited Jan 10 at 23:48
Pathfinder
1,043817
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
edited Jan 10 at 23:48
Pathfinder
1,043817
edited Jan 10 at 23:48
Pathfinder
1,043817
edited Jan 10 at 23:48
Pathfinder
1,043817
1,043817
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
asked Jan 10 at 21:44
Joelias AndradeJoelias Andrade
101
101
1
If you were to explain what you're actually trying to accomplish, and perhaps the context within which that requirement operates, we may be better able to suggest a solution. Right now you're using SQL terms (create, drop) to describe a circumstance you have explicitly stated will occur without SQL, so it's not particularly clear what you want.
– music2myear
Jan 10 at 21:56
There are many SQL-compliant databases, from Oracle to Firebird. Each is different.
– DrMoishe Pippik
Jan 10 at 22:49
I have an application with SQL database. One of the tables I do periodic maintenance . It has rates. Now and then I need to create new columns and for this I need to back up this table, drop it and recreate it. The application will be migrated to a new server where it will be prohibited to perform this routine maintenance on it. So, I would like to know how I can solve this by implementing directly in the c # / aspnet application. web.Does have on WEB anything to this issue?
– Joelias Andrade
Jan 10 at 23:49
Can you try to alter the table and add the column and ensure your SQL login has appropriate permissions to do so. You could run something likeALTER TABLE <table> ADD <column> VARCHAR(20) NULL
– Pimp Juice IT
Jan 10 at 23:57
Can I do it by frontend app?If it is possible, how can i do it?
– Joelias Andrade
Jan 11 at 0:12
|
show 1 more comment
1
If you were to explain what you're actually trying to accomplish, and perhaps the context within which that requirement operates, we may be better able to suggest a solution. Right now you're using SQL terms (create, drop) to describe a circumstance you have explicitly stated will occur without SQL, so it's not particularly clear what you want.
– music2myear
Jan 10 at 21:56
There are many SQL-compliant databases, from Oracle to Firebird. Each is different.
– DrMoishe Pippik
Jan 10 at 22:49
I have an application with SQL database. One of the tables I do periodic maintenance . It has rates. Now and then I need to create new columns and for this I need to back up this table, drop it and recreate it. The application will be migrated to a new server where it will be prohibited to perform this routine maintenance on it. So, I would like to know how I can solve this by implementing directly in the c # / aspnet application. web.Does have on WEB anything to this issue?
– Joelias Andrade
Jan 10 at 23:49
Can you try to alter the table and add the column and ensure your SQL login has appropriate permissions to do so. You could run something likeALTER TABLE <table> ADD <column> VARCHAR(20) NULL
– Pimp Juice IT
Jan 10 at 23:57
Can I do it by frontend app?If it is possible, how can i do it?
– Joelias Andrade
Jan 11 at 0:12
1
1
If you were to explain what you're actually trying to accomplish, and perhaps the context within which that requirement operates, we may be better able to suggest a solution. Right now you're using SQL terms (create, drop) to describe a circumstance you have explicitly stated will occur without SQL, so it's not particularly clear what you want.
– music2myear
Jan 10 at 21:56
If you were to explain what you're actually trying to accomplish, and perhaps the context within which that requirement operates, we may be better able to suggest a solution. Right now you're using SQL terms (create, drop) to describe a circumstance you have explicitly stated will occur without SQL, so it's not particularly clear what you want.
– music2myear
Jan 10 at 21:56
There are many SQL-compliant databases, from Oracle to Firebird. Each is different.
– DrMoishe Pippik
Jan 10 at 22:49
There are many SQL-compliant databases, from Oracle to Firebird. Each is different.
– DrMoishe Pippik
Jan 10 at 22:49
I have an application with SQL database. One of the tables I do periodic maintenance . It has rates. Now and then I need to create new columns and for this I need to back up this table, drop it and recreate it. The application will be migrated to a new server where it will be prohibited to perform this routine maintenance on it. So, I would like to know how I can solve this by implementing directly in the c # / aspnet application. web.Does have on WEB anything to this issue?
– Joelias Andrade
Jan 10 at 23:49
I have an application with SQL database. One of the tables I do periodic maintenance . It has rates. Now and then I need to create new columns and for this I need to back up this table, drop it and recreate it. The application will be migrated to a new server where it will be prohibited to perform this routine maintenance on it. So, I would like to know how I can solve this by implementing directly in the c # / aspnet application. web.Does have on WEB anything to this issue?
– Joelias Andrade
Jan 10 at 23:49
Can you try to alter the table and add the column and ensure your SQL login has appropriate permissions to do so. You could run something like
ALTER TABLE <table> ADD <column> VARCHAR(20) NULL– Pimp Juice IT
Jan 10 at 23:57
Can you try to alter the table and add the column and ensure your SQL login has appropriate permissions to do so. You could run something like
ALTER TABLE <table> ADD <column> VARCHAR(20) NULL– Pimp Juice IT
Jan 10 at 23:57
Can I do it by frontend app?If it is possible, how can i do it?
– Joelias Andrade
Jan 11 at 0:12
Can I do it by frontend app?If it is possible, how can i do it?
– Joelias Andrade
Jan 11 at 0:12
|
show 1 more comment
1 Answer
1
active
oldest
votes
I don't think what you are asking is practical - it appears akin to asking how to write a sentence without using characters. SQL is used to setup, manipulate, backup and otherwise handle MySQL databases.
Anything like xml or Jason or another description will, at some level need to be converted to sql to be injected into the database.
The only other solution I can think if - which us a hellishly bad idea - would be to become an expert on the file format representing the tables and manipulate these directly outside of MySQL. Of-course, the chance if causing corruption us extremely high, and you require MORE permissions/access to do this then to be granted appropriate permissions to alter tables in SQL.
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1392940%2fhow-to-create-and-drop-a-table-outside-of-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I don't think what you are asking is practical - it appears akin to asking how to write a sentence without using characters. SQL is used to setup, manipulate, backup and otherwise handle MySQL databases.
Anything like xml or Jason or another description will, at some level need to be converted to sql to be injected into the database.
The only other solution I can think if - which us a hellishly bad idea - would be to become an expert on the file format representing the tables and manipulate these directly outside of MySQL. Of-course, the chance if causing corruption us extremely high, and you require MORE permissions/access to do this then to be granted appropriate permissions to alter tables in SQL.
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
add a comment |
I don't think what you are asking is practical - it appears akin to asking how to write a sentence without using characters. SQL is used to setup, manipulate, backup and otherwise handle MySQL databases.
Anything like xml or Jason or another description will, at some level need to be converted to sql to be injected into the database.
The only other solution I can think if - which us a hellishly bad idea - would be to become an expert on the file format representing the tables and manipulate these directly outside of MySQL. Of-course, the chance if causing corruption us extremely high, and you require MORE permissions/access to do this then to be granted appropriate permissions to alter tables in SQL.
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
add a comment |
I don't think what you are asking is practical - it appears akin to asking how to write a sentence without using characters. SQL is used to setup, manipulate, backup and otherwise handle MySQL databases.
Anything like xml or Jason or another description will, at some level need to be converted to sql to be injected into the database.
The only other solution I can think if - which us a hellishly bad idea - would be to become an expert on the file format representing the tables and manipulate these directly outside of MySQL. Of-course, the chance if causing corruption us extremely high, and you require MORE permissions/access to do this then to be granted appropriate permissions to alter tables in SQL.
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
I don't think what you are asking is practical - it appears akin to asking how to write a sentence without using characters. SQL is used to setup, manipulate, backup and otherwise handle MySQL databases.
Anything like xml or Jason or another description will, at some level need to be converted to sql to be injected into the database.
The only other solution I can think if - which us a hellishly bad idea - would be to become an expert on the file format representing the tables and manipulate these directly outside of MySQL. Of-course, the chance if causing corruption us extremely high, and you require MORE permissions/access to do this then to be granted appropriate permissions to alter tables in SQL.
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
answered Jan 11 at 9:39
davidgodavidgo
43.6k75291
43.6k75291
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1392940%2fhow-to-create-and-drop-a-table-outside-of-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
If you were to explain what you're actually trying to accomplish, and perhaps the context within which that requirement operates, we may be better able to suggest a solution. Right now you're using SQL terms (create, drop) to describe a circumstance you have explicitly stated will occur without SQL, so it's not particularly clear what you want.
– music2myear
Jan 10 at 21:56
There are many SQL-compliant databases, from Oracle to Firebird. Each is different.
– DrMoishe Pippik
Jan 10 at 22:49
I have an application with SQL database. One of the tables I do periodic maintenance . It has rates. Now and then I need to create new columns and for this I need to back up this table, drop it and recreate it. The application will be migrated to a new server where it will be prohibited to perform this routine maintenance on it. So, I would like to know how I can solve this by implementing directly in the c # / aspnet application. web.Does have on WEB anything to this issue?
– Joelias Andrade
Jan 10 at 23:49
Can you try to alter the table and add the column and ensure your SQL login has appropriate permissions to do so. You could run something like
ALTER TABLE <table> ADD <column> VARCHAR(20) NULL– Pimp Juice IT
Jan 10 at 23:57
Can I do it by frontend app?If it is possible, how can i do it?
– Joelias Andrade
Jan 11 at 0:12