Link to home
Start Free TrialLog in
Avatar of N_Sri
N_Sri

asked on

Sql Server : Finding tables that use small int

Hi ,
 Please help to write a query  to find all the tables in my Database , which has  small int has datatype and there column names
once again Find all tables  which have column  datatype as smallint and the column names.
Quick response is highly appreciable.



Thankyou
ASKER CERTIFIED SOLUTION
Avatar of sventhan
sventhan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of N_Sri
N_Sri

ASKER

thankyou