SQLServerCentral / Article Discussions / Discuss content posted by Mohit Nayyar / Article Discussions by Author / Get the Table Structure using a simple query / Latest Posts

RE: Get the Table Structure using a simple query

Hardy21 — Mon, 13 Sep 2010 00:02:19 GMT

I am looking for this query. Thanks

RE: Get the Table Structure using a simple query

Uttam Kr. Dhar — Sun, 12 Sep 2010 23:49:06 GMT

U can get better information in the following query:Select sysObj.id, sysObj.name, Col.name,'Datatype'=Case When typ.name in ('char','varchar') Then typ.name+'('+Cast(Col.max_length as varchar(10))+')' When typ.name = 'nvarchar' AND Col.max_length<>-1 Then typ.name+'('+Cast(Col.max_length/2 as varchar(10))+')' When typ.name = 'nvarchar' AND Col.max_length=-1 Then typ.name+'(MAX)' When typ.name = 'decimal' Then typ.name+'('+Cast(Col.precision as varchar(5))+','+Cast(Col.scale as varchar(5))+')' Else typ.nameEnd, 'Length'=Col.max_length, 'isNullable'=Case When Col.is_nullable = 1 Then 'Yes' Else 'No' End,'isIdentity'=Case When Col.is_identity = 1 Then 'Yes' Else 'No' End, Col.column_idFrom sys.columns Col Inner Join sys.sysobjects sysObj ON sysObj.id = Col.object_idInner Join sys.types typ ON typ.user_type_id = Col.user_type_idWhere sysObj.xtype = 'U'and sysObj.name like 'ma_Parts%'order by sysObj.name, Col.column_id;

RE: Get the Table Structure using a simple query

Ayyappan Thangaraj — Thu, 27 May 2010 07:15:26 GMT

Dear Mohit,I have executed the SQL query. It is giving the exact output that you are saying.I found one issue in the output information. if you look it the datatype, it is showing one strange datatype name sysdata in the table structure actually in should not come.can you please look into it and change the query?Thanks,Ayyappan

Get the Table Structure using a simple query

Mohit Nayyar — Tue, 25 Sep 2007 02:29:52 GMT

Comments posted to this topic are about the item [B]Get the Table Structure using a simple query[/B]