Which system table contains information on constraints on
all the tables created?
Answer Posted / priya reddy
user_constraints table will contain the information on
constraints on all the tables created.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How to delete duplicate records based on single column from a table?
How to write a query with an inner join in ms sql server?
How to create new table with "create table" statements?
What is the difference between composite index and covering index?
what are the critical issues you have resloved in your company
What do you understand by SQL*Net?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
In what sequence sql statement is processed?
Write the syntax for stuff function in an sql server?
Explain aggregate functions?
What are logical/boolean operations in ms sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are commonly used mssql functions in php?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Do you know what is bit data type and whats the information that can be stored inside a bit column?