Click here to Skip to main content
15,357,682 members
Home / Discussions / Database
   

Database

 
GeneralRe: Database design questions Pin
Saksida Bojan24-Aug-09 7:28
MemberSaksida Bojan24-Aug-09 7:28 
GeneralRe: Database design questions Pin
N a v a n e e t h24-Aug-09 16:56
MemberN a v a n e e t h24-Aug-09 16:56 
QuestionOracle Equalent for Systypes and Syscolumns... Pin
sandhya1423-Aug-09 22:48
Membersandhya1423-Aug-09 22:48 
Questionget all parent tables name with child from sql 2005 Pin
Abdul Rahman Hamidy23-Aug-09 18:26
MemberAbdul Rahman Hamidy23-Aug-09 18:26 
AnswerRe: get all parent tables name with child from sql 2005 Pin
Mycroft Holmes23-Aug-09 19:34
professionalMycroft Holmes23-Aug-09 19:34 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Abdul Rahman Hamidy23-Aug-09 20:23
MemberAbdul Rahman Hamidy23-Aug-09 20:23 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Mycroft Holmes23-Aug-09 21:19
professionalMycroft Holmes23-Aug-09 21:19 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Abdul Rahman Hamidy24-Aug-09 1:57
MemberAbdul Rahman Hamidy24-Aug-09 1:57 
well, i have done this which returns the requirement, but only it does not returns parent tables first then child tables.
would u help me to return parent tables first than child tables.
select distinct(t.name),t.[object_id] from sys.tables t left join sys.foreign_keys k
on t.object_id=k.parent_object_id
where t.[type]='U' and t.is_ms_shipped=0 and t.[name] not like 'asp%' and t.[name] not like 'sys%'
order by t.[name] desc


Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

QuestionStoring data which in the form of a list to database. Pin
udaykatakam21-Aug-09 8:04
Memberudaykatakam21-Aug-09 8:04 
AnswerRe: Storing data which in the form of a list to database. Pin
Mycroft Holmes21-Aug-09 17:18
professionalMycroft Holmes21-Aug-09 17:18 
GeneralRe: Storing data which in the form of a list to database. Pin
udaykatakam23-Aug-09 21:32
Memberudaykatakam23-Aug-09 21:32 
GeneralRe: Storing data which in the form of a list to database. Pin
Mycroft Holmes23-Aug-09 21:48
professionalMycroft Holmes23-Aug-09 21:48 
GeneralRe: Storing data which in the form of a list to database. Pin
udaykatakam24-Aug-09 11:29
Memberudaykatakam24-Aug-09 11:29 
QuestionAbout the SQL Execution Plan Pin
mctramp16820-Aug-09 22:09
Membermctramp16820-Aug-09 22:09 
AnswerRe: About the SQL Execution Plan Pin
Ashfield20-Aug-09 23:19
MemberAshfield20-Aug-09 23:19 
AnswerRe: About the SQL Execution Plan Pin
Mycroft Holmes21-Aug-09 0:38
professionalMycroft Holmes21-Aug-09 0:38 
GeneralRe: About the SQL Execution Plan Pin
David Mujica21-Aug-09 2:54
MemberDavid Mujica21-Aug-09 2:54 
QuestionSQL:Find one primary key of each duplicate records Pin
xodeblack20-Aug-09 19:42
Memberxodeblack20-Aug-09 19:42 
AnswerRe: SQL:Find one primary key of each duplicate records Pin
Ashfield20-Aug-09 21:01
MemberAshfield20-Aug-09 21:01 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack20-Aug-09 21:25
Memberxodeblack20-Aug-09 21:25 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 1:21
MemberAshfield21-Aug-09 1:21 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack21-Aug-09 1:28
Memberxodeblack21-Aug-09 1:28 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 4:20
MemberAshfield21-Aug-09 4:20 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Coding C#20-Aug-09 22:25
MemberCoding C#20-Aug-09 22:25 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
David Skelly20-Aug-09 22:32
MemberDavid Skelly20-Aug-09 22:32 

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.