Click here to Skip to main content
15,504,703 members
Home / Discussions / Database
   

Database

 
GeneralRe: INSERT trigger - how to stop the insert from happening. Pin
Werries17-Apr-08 10:56
Werries17-Apr-08 10:56 
GeneralRe: INSERT trigger - how to stop the insert from happening. Pin
SimulationofSai17-Apr-08 22:22
SimulationofSai17-Apr-08 22:22 
GeneralSystem.Data.OleDb.OleDbException: Unspecified error Pin
tom8317-Apr-08 4:35
tom8317-Apr-08 4:35 
GeneralRe: System.Data.OleDb.OleDbException: Unspecified error Pin
Kschuler17-Apr-08 11:37
Kschuler17-Apr-08 11:37 
Generalline 18 is getting error near ''this codes(mysql) Pin
srinivassam17-Apr-08 1:53
srinivassam17-Apr-08 1:53 
GeneralRe: line 18 is getting error near ''this codes(mysql) Pin
R. Giskard Reventlov17-Apr-08 2:16
R. Giskard Reventlov17-Apr-08 2:16 
GeneralCopy from one table into another Pin
.NET- India 17-Apr-08 1:52
.NET- India 17-Apr-08 1:52 
GeneralRe: Copy from one table into another Pin
pmarfleet17-Apr-08 2:57
pmarfleet17-Apr-08 2:57 
.NET- India wrote:
How to copy database design of a table into another table without copying its values


If you want to do this manually, you can do this through Management Studio by right-clicking a table and selecting 'Script Table As... -> CREATE TO'.

If you want do do it in code, you could use SMO[^] to obtain metadata for a particular table and create another table based on this metadata.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush


GeneralRe: Copy from one table into another Pin
SimulationofSai17-Apr-08 4:04
SimulationofSai17-Apr-08 4:04 
Generalmysql provider problem Pin
srinivassam17-Apr-08 1:28
srinivassam17-Apr-08 1:28 
GeneralERROR:40 Pin
A-MEN16-Apr-08 23:02
A-MEN16-Apr-08 23:02 
GeneralRe: ERROR:40 Pin
R. Giskard Reventlov17-Apr-08 0:36
R. Giskard Reventlov17-Apr-08 0:36 
GeneralConvert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 22:47
subbu.sk16-Apr-08 22:47 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
pmarfleet16-Apr-08 23:18
pmarfleet16-Apr-08 23:18 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 23:37
subbu.sk16-Apr-08 23:37 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 23:37
subbu.sk16-Apr-08 23:37 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
subbu.sk16-Apr-08 23:37
subbu.sk16-Apr-08 23:37 
GeneralRe: Convert date formate 4th april 2008 to default date formate Pin
Paddy Boyd17-Apr-08 0:23
Paddy Boyd17-Apr-08 0:23 
GeneralView verses Table-Values Function Pin
Werries16-Apr-08 20:53
Werries16-Apr-08 20:53 
GeneralRe: View verses Table-Values Function Pin
Ashfield16-Apr-08 22:03
Ashfield16-Apr-08 22:03 
GeneralGetting Top 5 from table of same category Pin
honeyss16-Apr-08 20:23
honeyss16-Apr-08 20:23 
GeneralRe: Getting Top 5 from table of same category Pin
ChandraRam16-Apr-08 21:08
ChandraRam16-Apr-08 21:08 
GeneralRe: Getting Top 5 from table of same category Pin
honeyss16-Apr-08 23:38
honeyss16-Apr-08 23:38 
GeneralRe: Getting Top 5 from table of same category Pin
ChandraRam17-Apr-08 2:33
ChandraRam17-Apr-08 2:33 
QuestionSql Query Pin
~V~16-Apr-08 2:44
~V~16-Apr-08 2:44 

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.