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
What is index in an assignment?
How do I view views in sql server?
What is the difference between row_number and dense_rank?
What do you mean by SQL injection attack?
Explain syntax for viewing, dropping and disabling triggers?
What is a print index?
What is the simplest way to create a new database in ms sql server?
How to create new tables with "select ... Into" statements in ms sql server?
What is the purpose of optimization?
How many databases instances are there in sql server 2000?
What is cube dimension? : sql server analysis services, ssas
How to return the date part only from a sql server datetime datatype?
What do you mean by an execution plan?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain an incremental backup?