Click here to Skip to main content
15,904,339 members
Home / Discussions / Database
   

Database

 
GeneralRe: Case-Sensative Password Column in SQL Anywhere 10 Pin
PIEBALDconsult24-Feb-10 14:10
mvePIEBALDconsult24-Feb-10 14:10 
GeneralRe: Case-Sensative Password Column in SQL Anywhere 10 Pin
WoutL24-Feb-10 19:50
WoutL24-Feb-10 19:50 
GeneralRe: Case-Sensative Password Column in SQL Anywhere 10 Pin
David Skelly24-Feb-10 22:46
David Skelly24-Feb-10 22:46 
GeneralRe: Case-Sensative Password Column in SQL Anywhere 10 Pin
MWRivera25-Feb-10 3:51
MWRivera25-Feb-10 3:51 
GeneralRe: Case-Sensative Password Column in SQL Anywhere 10 Pin
David Skelly25-Feb-10 6:14
David Skelly25-Feb-10 6:14 
GeneralRe: Case-Sensative Password Column in SQL Anywhere 10 Pin
MWRivera25-Feb-10 6:27
MWRivera25-Feb-10 6:27 
GeneralRe: Case-Sensative Password Column in SQL Anywhere 10 Pin
MWRivera3-Mar-10 4:37
MWRivera3-Mar-10 4:37 
QuestionOracle Primary key Pin
MsmVc24-Feb-10 0:01
MsmVc24-Feb-10 0:01 
Hi all
how can i get Primary key column name from table?I find some tips from google but it's not working always show no row selected.
select all_constraints.index_name, all_ind_columns.column_name, all_ind_columns.column_position from all_constraints, all_ind_columns where all_constraints.owner = all_ind_columns.index_owner and all_constraints.constraint_name = all_ind_columns.index_name and all_constraints.constraint_type = 'P' and all_constraints.owner = 'DBO' and all_constraints.table_name = UPPER('VARTABLE') order by all_constraints.index_name asc, all_ind_columns.column_position asc, all_ind_columns.column_name asc

please help me.
AnswerRe: Oracle Primary key Pin
Mycroft Holmes24-Feb-10 0:50
professionalMycroft Holmes24-Feb-10 0:50 
GeneralRe: Oracle Primary key Pin
MsmVc24-Feb-10 0:52
MsmVc24-Feb-10 0:52 
AnswerRe: Oracle Primary key Pin
David Skelly24-Feb-10 1:57
David Skelly24-Feb-10 1:57 
QuestionSSIS Connection Problem in C# Pin
Vimalsoft(Pty) Ltd23-Feb-10 20:15
professionalVimalsoft(Pty) Ltd23-Feb-10 20:15 
AnswerRe: SSIS Connection Problem in C# Pin
R. Giskard Reventlov24-Feb-10 3:19
R. Giskard Reventlov24-Feb-10 3:19 
GeneralRe: SSIS Connection Problem in C# Pin
Vimalsoft(Pty) Ltd24-Feb-10 4:09
professionalVimalsoft(Pty) Ltd24-Feb-10 4:09 
QuestionDateTime ; between query in SQL SERVER 2000 Pin
Karan_TN23-Feb-10 1:58
Karan_TN23-Feb-10 1:58 
AnswerRe: DateTime ; between query in SQL SERVER 2000 Pin
WoutL23-Feb-10 2:19
WoutL23-Feb-10 2:19 
AnswerRe: DateTime ; between query in SQL SERVER 2000 Pin
Luc Pattyn23-Feb-10 2:32
sitebuilderLuc Pattyn23-Feb-10 2:32 
GeneralRe: DateTime ; between query in SQL SERVER 2000 Pin
WoutL23-Feb-10 2:36
WoutL23-Feb-10 2:36 
GeneralRe: DateTime ; between query in SQL SERVER 2000 Pin
Luc Pattyn23-Feb-10 2:41
sitebuilderLuc Pattyn23-Feb-10 2:41 
AnswerRe: DateTime ; between query in SQL SERVER 2000 Pin
Luc Pattyn23-Feb-10 2:31
sitebuilderLuc Pattyn23-Feb-10 2:31 
GeneralRe: DateTime ; between query in SQL SERVER 2000 Pin
Karan_TN23-Feb-10 2:47
Karan_TN23-Feb-10 2:47 
AnswerRe: DateTime ; between query in SQL SERVER 2000 Pin
Luc Pattyn23-Feb-10 3:21
sitebuilderLuc Pattyn23-Feb-10 3:21 
AnswerRe: DateTime ; between query in SQL SERVER 2000 [modified] Pin
Chris Meech23-Feb-10 7:06
Chris Meech23-Feb-10 7:06 
AnswerRe: DateTime ; between query in SQL SERVER 2000 Pin
Adam Jasper24-Feb-10 2:52
Adam Jasper24-Feb-10 2:52 
QuestionSQL Anywhere 10 Password Field Pin
MWRivera22-Feb-10 10:17
MWRivera22-Feb-10 10:17 

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.