how to know description of a table in sqlserver 2000
Answer Posted / ksantosha
Dear Srinivas,
desc using in oracle not in Sql Server.
sp_help <table_name> is correct answer for Sql server
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Can sql server 2016 run on windows 7?
What is the report builder?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Do you know clustered and non-clustered index?
What is triggers and stored procedures?
What is public role in sql server?
What functions can a view be used to performed?
What do you understand by mirroring and mention the advantages of the mirroring?
Tell me what are the essential components of sql server service broker?
What are functions in the sql server?
Explain the microsoft sql server delete command? : SQL Server Architecture
What is sql server schema compare? How we can compare two database schemas?
What is the purpose of sql profiler in sql server?
Explain the ways to controlling cursor behavior?
What is an identity?