I have a situation in which I have to copy the schema of a table to another table in Oracle. I do not want to copy the data of that table. How can I copy the structure of a table without copying the data?

I want to create database relationships like one to one, one to many and many to many relationship.

I am using SQL Server 2008 R2. Can anyone please tell me that how can I implement one-to-one, one-to-many and many-to-many relationships while designing tables?

There are few database files in my Data Folder of SQL Server directory. I want to delete those files, but when I try to delete them, system says that the files are being used. But those files are not associated with any database and are no longer showing in my Databases.

How can I delete those files because they are just occupying space on hard disk?

How can I make sure that a table called Table2 with a field called Field1 will only have the values as in Field1 that are also in another table called Table1 with a field called Field1? How can I force Table2 to contain the values as in Table1?

I am facing a problematic scenario with my database table. I have a database table which is parent and it has got some garbage values. Now, I want to drop this table. Is there any way that I can drop this table and recreate it without affecting its child tables?

I have attached the database in SQL Server 2005 using .mdf file. But as soon as it was attached, database went to suspected mode. I tried a set of statements to recover it to normal state but after running those queries, its status changed to emergency mode.

Can you please tell me that how can I recover my database from emergency mode to normal?

I have windows application having button on it. Behind that button a SQL query is written. Now when you press the button that query executes. Is there any way to see the query written behind the button, if source code is not available?

You are given the following data.

Hi,

I am a new user of SQL server 2000 Home Edition. Please any one tell me procedure how can I install it in my computer?

Thanks.

I have this code to remove the FOREIGN KEY.

ALTER TABLE ORDERS DROP FOREIGN KEY CUSTOMERID;

When I try to run the code an error message appears:

ERROR 1025 (HY000): Error on rename of './TESTDB/ORDERS' to './TESTDB/#sql2-3b5b-8'

(err no: 152)

What does this message mean. Is my syntax wrong? By the way, I only want to remove the FOREIGN KEY on the CUSTOMERID but don't want any changes for the rest of the database.