Interested to Buy Any Domain ? << Click Here >> for more details...
How to list all tables having unique constraints in any of
the columns in a database.
- 1 Answers
- 4535 Views
- I also Faced
- E-Mail Answers
Answer / rama krishna
select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where
constraint_type='unique'
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the difference between char, varchar and nvarchar?
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
About Indexed Views? with example? plz reply...
please differentiate between delete and truncate?
What is resultset concur_updatable?
How to install sql server 2005 express edition?
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 Answers CarrizalSoft Technologies, IBM,
Write an sql query to find first weekday of the month?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
how to get rank of diffrent student in same table based on newly inserted row in sql server2008
What are Sql Reporting Services and analysis services? Can u Explain
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
