Explain system views?
Answer / Rinku Sharma
System views in SQL Server are predefined views that provide information about various aspects of the database and its objects. Examples include sys.databases, sys.tables, and sys.columns. These views can be queried to retrieve detailed information about the database's structure, statistics, and runtime information.
| Is This Answer Correct ? | 0 Yes | 0 No |
Which tcl commands are available on the sql server?
i want table name basis on column name.
Difference between server.transfer and server.execute method?
What is an Index?
what is a deadlock? : Sql server database administration
What is a NOLOCK?
What are the main sources of data?
What is the difference between login and a user?
13 Answers CTS, TCS,
What is Schema in Database?
How to check status of stored procedure in sql server?
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
Explain boyce and codd normal form(bcnf)?
Oracle (3253)
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)