How to list all tables having unique constraints in any of
the columns in a database.
Answer / rama krishna
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
constraint_type='unique'
Is This Answer Correct ? | 4 Yes | 0 No |
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
0 Answers Amdocs, Apps Associates,
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
when you create a database how is it stored? : Sql server database administration
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
Do you know what are the properties of the relational tables?
What are the properties and different types of sub-queries?
Where are sql server usernames and passwords stored in the sql server?
How to create Clustered Primary Key to table?
What is partition in sql server?
List the different types of joins?
Explain user defined functions?
Explain the disadvantages of cursors?