Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

re table creation

This is a discussion on re table creation within the SQL forums, part of the Databases category; i want t to create a table in that 3 columns are there one is const_id (PK) and const_type foreignkey (const_id) and const name is it possible to me help ...

Geeks Talk > Databases > SQL re table creation

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   02-18-2008

sureshvempati Junior Member   Join Date: Feb 2008 Location: hyderabad Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

re table creation i want t to create a table in that 3 columns are there one is const_id (PK) and const_type foreignkey (const_id) and const name is it possible to me help me urgently plz send mail to me "mail id removed"

Sponsored Links

#2 (permalink)   02-18-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: re table creation What is the problem then ?

#3 (permalink)   02-18-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 64 Times in 63 Posts

Re: re table creation Yes, you can create table in the following way create table xxxx ( const_id varchar2(10) constraint xxxx_pk primary key, const_type varchar2(10) constraint xxxx_fk references xxxx(const_id), const_name varchar2(30) ) But what is the use of creating such a table?

Geeks Talk > Databases > SQL

« please, help me | Oracle SQL »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
JTable creation in swing	ssgvenkat2002	Java	1	01-30-2008 10:02 AM
DTS Package Creation	Siva_Tech	SQL	2	09-18-2007 02:32 AM
Html Page Creation	suddu0308	JavaScript	6	06-27-2007 01:40 PM
Online Database creation	Innila	Database General	2	02-01-2007 03:45 AM
Online Database creation	Innila	Database General	1	01-12-2007 08:56 AM

All times are GMT -4. The time now is 05:52 PM.