how can i view structure of table in sql server? tell me
that query.
Answer Posted / sathish
how can i view structure of table in sql server? tell me
that query.
Select * from information_schema.columns where table_name =
xyz
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write a program to fetch first 10 records from a file?
Find columns used in stored procedure?
What is BCNF? How is it better than 2NF & 3NF?
What do you mean by an execution plan?
How to sort the query output with order by clauses in ms sql server?
is there a column to which a default can't be bound? : Sql server database administration
What are the tool windows in sql server management studio? : sql server management studio
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is similarity and difference between truncate and delete in sql?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is candidate key with example?
How do you delete a trigger?
Where can you find the error log information? : sql server database administration
whats new about truncate in sql server 2008?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?