how to know description of a table in sqlserver 2000
Answer Posted / sharif
Yes The Ksanthosha Given the Right Answer!
SP_HELP TABLE_NAME
This will gives the descriptin about the given TABLE_NAME
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to use transact-sql statements to access the database engine?
Explain the use of containers in ssis and also their types?
What are the database objects? : SQL Server Architecture
What do you think of this implementation? Can this be implemented better?
What do you understand by replication in sql server?
What is co-related sub query?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
what's the difference between a primary key and a unique key? : Sql server database administration
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What is the use of tempdb? What values does it hold?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the types of processing and explain each? : sql server analysis services, ssas
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What stored by the master? : sql server database administration
What is always encrypted?