How do I list the available tables in a database I'm
querying?
Answer Posted / shraddha
sp_tables
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is subquery in sql?
How to get the definition of a user defined function back?
Write a sql query to get zero records from a table having n number of records?
What do you understand by recursive stored procedure?
Explain the disadvantages of cursors?
What is exporting utility?
what are database files and filegroups? : Sql server database administration
What is read committed?
Write a sql query to sort on different column name according to the parameters passed in the function?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Difference between primary key and clustered index?
What is truncate table?
Does a server store data?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What are scalar functions?